Answer Posted / kumarapillaietl@gmail.com
in before informatica powercenter 9 version lookup it is works passive tranformation ,after that 9X lookup works both passive and active ,
informatica provide aditional features, at the time of lookup creation (multi match) check bok option is there , when you check multi match its works active.
genraly we can get source table,target tables,flatfiles al lthous thinks and compare hetroginious sources using lookup.
lookup participate each SCD mappig flow.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between mapping parameter and mapping variable?
Under what condition selecting sorted input in aggregator may fail the session?
Explain the scenario which compels informatica server to reject files?
What is enterprise data warehousing?
How do you update the records with or without using update strategy?
What is meant by LDAP users?
What are the limitations of joiner transformation?
What are ETL Tools?
What are the tasks that source qualifier perform?
how tokens will generate?
How to delete duplicate row using informatica?
What is meant by lookup transformation?
Explain what transformation and how many are there in informatica?
What are the advantages of using informatica as an etl tool over teradata?
What is a mapplet/worklet in informatica?