[T-SQL] DBCC LOGINFO

Do you know that there are multiple small log files in the large log file (LDF). So now your next question would be how can we know that.

Veri simple method

DBCC LOGINFO

You would find the file size and other relevant information in the resultant.

[ORACLE] How to import dump file to different table space

1.With your .DMP file, create a SQL file containing the structure (Tables):
imp evolvrepo/password@ORCL file=evolvrepo.dmp indexfile=index.sql full=y

2.Open the indexfile (index.sql) in a text editor that can do find and replace over an entire file, and issue the following find and replace statements IN ORDER (ignore the single quotes.. '):

a.Find: 'REM' Replace:

b.Find: '""' Replace: '"#tablespace#"'

c.Find: '...' Replace: 'REM ...'

d.Find: 'CONNECT' Replace: 'REM CONNECT'


3.Save the indexfile, then run it at command prompt
echo exit|sqlplus evolvrepo/password@ORCL @index.sql

4.Finally run the same .DMP file you created the indexfile with against the same account to import the data, stored procedures, views etc:
imp evolvrepo/password@ORCL full=y file=evolvrepo.dmp buffer=326000 log=evolvrepo.log


Note: Replace #tablespace# with table space name and #TEMP1# with temporary tablespace name.

[T-SQL] Paging in SQL Server 2011

So here is now the new feature of sql server in its latest edition , so here is how you can use paging , i mean server side paging for fetching rows or result set in pages.

USE AdventureWorks2008R2
GO
DECLARE @RowsPerPage INT = 10, @PageNumber INT = 5
SELECT *
FROM Sales.SalesOrderDetail
ORDER BY SalesOrderDetailID
OFFSET @PageNumber*@RowsPerPage ROWS
FETCH NEXT 10 ROWS ONLY
GO

[Informatica] Powermart Command Prompt pmcmd

Here is the way how you can execute the workflow from command prompt:

./pmcmd
pmcmd> connect -sv TestingRepoIntegrationService1 -d Primatics_corvus.primaticsfinancial.com -u uname -p password
pmcmd> setfolder "Demo Mapping"
pmcmd> startworkflow Main_Model_Bank

---- Description
sv: Integration Service Name
d: Domain Name
u: username
p: password
setfolder: tell the folder name where workflow has been placed
startworkflow : tell the workflow name

[T-SQL] Find Space Used For Any Particular Table

Use Temp;
Go
EXEC sp_spaceused 'Temp1';
GO

You will get the following details:

1. Name
2. Rows
3. Reserved
4. Data
5. Index Size
6. Unused

[Informatica] Tutorials

Here are some initial tutorials for how to work with informatica.

How to create mapping , session , workflow using Informatica Powercenter:

http://www.youtube.com/watch?v=zkJoet5jBtE

Workflow Properties:

http://www.youtube.com/watch?v=2FiFLaNkwnY

Let me know if you have any queries regarding any steps that are defined in between.

[Informatica] New Label

I have started working on Informatica , so now i would also start posting some good material realated to Informatica with the label [Informatica]

I am working on the following tools:

Informatica 9.0.1
=> Power Center Designer
=> Power Center Workflow Manager
=> Power Center Workflow Monitor

For any queries , do let me know.