Answer Posted / ankit kansal
Lookup is used to check whether the row corresponding the incoming row is present or not and if yes then perform some logic and if not then do some other like we use to do it case of SCD2.
So, It is purely a left outer join where left table is your source table.
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how do u set partition points in the mapping?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Compare etl & elt?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
how do u extract data from different data sources explain with an example?
What is a lookup table in etl?
What are cubes and olap cubes?
what is a worklet?
Can we create Hierarchies in generic datasources?
what are Lookup caches options? Including persistent caches.
What are the various tools used in etl?
what happens if the info.server doesn't find the session parameter in the parameter file?
Difference between flat files and relational sources?
How etl testing is different from database testing?
where are the log files generally stored.Can you change the path of the file.what can the path be?