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 is pmcmd command?
explain one complex mapping with logic? sales project?
How to create a non-reusable instance of reusable transformations?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Explain in detail about scd type 1 through mapping.
Different circumstance which drives informatica server to expel records?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
what are the deliverables?in your project?
What is workflow? What are the components of workflow manager?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is a node in Informatica?
tell me about your project functionality
What are the tuning techniques you applied during your last project
difference between repository database and repository service?
What is the scenario which compels informatica server to reject files?