bala

• Jul 27th, 2006

 

Hi Kalpana,

Stored Procedure Transformation : It is a passive and both connected and unconnected transformation. It is useful to automate time consuming tasks and also used to create and drop the indexes and also used in error handling.It must exist in the database before creating the stored procedure transformation.

Sequence Generator Transformation : It is a passive and connected transformation. It is used to create unique primary key values

Lookup Transformation : It is a passive and both connected and unconnected transformation. It is used to lookup data from in a relational table, view or synonym. Lookup definition can be imported either from source or target tables

prasoon

• Aug 7th, 2006

 

hi1

i would like to share something more about Look ups.

We  have connected ,unconnected look up and static and dynamic look ups.

dynamic look ups are very useful when we need to perform insert or update on target.

e.g.if we have data about clients and we have maintained it with last updated date.Now we want to insert only new customers to target and update "last updated date"for the existing clients.

Then we will use dynamic look up.

Please go through informatica help and read about this and contact me for any further doubt.