Why lookup is Active in informatica 9.x?
Active Transformation:
An active Transformation can change the number of rows that pass through it form source to target i.e it eliminates rows that do not meet the condition in transformation.
Passive Transformation:
A passive transformation does not change the number of rows that pass through it i.e it passes all rows through the transformation.
In Informatica 9.x Lookup can return multiple rows on Successful match.
Properties > Lookup Policy on Multiple match
Active Transformation:
An active Transformation can change the number of rows that pass through it form source to target i.e it eliminates rows that do not meet the condition in transformation.
Passive Transformation:
A passive transformation does not change the number of rows that pass through it i.e it passes all rows through the transformation.
In Informatica 9.x Lookup can return multiple rows on Successful match.
Properties > Lookup Policy on Multiple match
No comments:
Post a Comment