[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.