What is a look up function? What is default transformation for the look up function?

pranusha

• Nov 8th, 2012

The lookup function is used to compare source data with another table based on a certain condition. If the condition is true than the lookup function returns columns that satisfy condition.
The default transformation for lookup function is lookup transformation.

Answer Question  Select Best Answer

What is the difference between STOP and ABORT options in Workflow Monitor?

Satish

• Mar 4th, 2014

STOP ensures current session activity / threads on Informatica server are complete and ends the workflow.
ABORT kills current session activity / threads on Informatica server irrespective of its state and ends the workflow.

Sudha Rani

• Nov 6th, 2012

If we have to do stop it will stop that step only.again we have to start the workflow then that time it will start which step u have to stop that step only it start run the workflow then abort says we...

Answer Question  Select Best Answer

can we update target table without using update strategy transformation?

MAHESH MANAM

• Aug 22nd, 2012

Yes, By using session level properties. In that use follow the steps Session --> Edit --> Properties --> Treat source rows as --> Update and also you should check options in Mapping --> Target --> U...

pranyarockvi

 Profile Answers by pranyarockvi Questions by pranyarockvi

• Jul 30th, 2012

Yes we can , it is the just that update strategy is used for conditional updates, and the update option available at the mapping level in the target is update without any condition.

Answer Question  Select Best Answer