kavitha rangdhale

 Profile Answers by kavitha rangdhale 

• Mar 22nd, 2006

 

Look up transformation is used to lookup the data in a relationa table,view,Synonym and Flat file.

The informatica server queries the lookup table based on the lookup ports used in the transformation.

It compares the lookup transformation port values to lookup table column values based on the lookup condition

By using lookup we can get the realated value,Perform a caluclation and Update SCD.

Two types of lookups

Connected

Unconnected

Update strategy transformation

This is used to control how the rows are flagged for insert,update ,delete or reject.

To define a flagging of rows in a session it can be insert,Delete,Update or Data driven.

In Update we have three options

Update as Update

Update as insert

Update else insert

Kathir

• Oct 6th, 2006

 

In Lookup transformation the source table look to the other tables what the destination you need

But in update stratergy you required empty field you have to fill it

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 13th, 2011

 

Look up transformation helps us to look for a data in a flat file,relational,view synonym. Lookup transformation can be used to get a related value and in a slowly changing dimensions

Update strategy transformation helps us to maintain histroy or current data in data warehouse. it can be used to insert, update, delete or reject date using the options like dd_insert, dd_update,dd_delete, dd_reject