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
Difference between Target-based loading and constraint-based loading?
What are the designer tools for creating transformations?
what are 3 tech challenges/ common issues you face?
Explain the code page compatibility?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
how many types of dimensions are available in informatica?
Explain incremental aggregation in informatica
What is the Rank index port in Rank transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
hi real timers . iam waiting for ur reply regarding ETL TESTING
expain about the tune parameters?
What are active transformations.
Briefly explain the aggregator transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is a mapplet/worklet in informatica?