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
How to extract the informatica rejected data?
What if the source is a flat-file?
How big was your fact table
What does refresh system mean, and what are its distinctive choice?
What is olap (on-line analytical processing?
What are active transformations.
Differentiate between reusable transformation and mapplet.
Please let me know how to make encryption and decryption with example?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
what are the deliverables?in your project?
What is the difference between a repository server and a powerhouse?
When do you use sql override in a lookup transformation?
How to create Target definition for flat files?
What is dimensional table?
What is informatica?