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
What do you mean by channel change?
Enlist the advantages of informatica.
What is informatica etl tool?
How can you validate all mappings in the repository simultaneously?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain about Informatica server process that how it works relates to mapping variables?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are different types of transformations available in informatica?
How we can create indexes after completing the loan process?
Difference between Data and Index Caches?
what is the size of u r source(like file or table)?
In how many ways we can create ports?
What is expression transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
