What is a diff between joiner and lookup transformation
Answer Posted / guest
If you are not a performance geek, somewhat basic things
you can do with both joiner and lookup t/f. However Joiner
operates on sources where as lookup operates source as well
as target. there are other things can also be identified as
limitation of working with heterogenious sources in both
the case.(can lookup work on xml file?)
Is This Answer Correct ? | 7 Yes | 19 No |
Post New Answer View All Answers
What are the components of Informatica? And what is the purpose of each?
What is workflow? What are the components of the workflow manager?
Explain the use of aggregator cache file?
What is meant by a domain?
What is a filter transformation?
What is informatica metadata and where is it stored?
What does refresh system mean, and what are its distinctive choice?
What is resilience time?
Explain sessions and how many types of sessions are there?
Reusable transformation and shortcut differences
What are the modules in Power Center
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to update a particular record in target with out running whole workflow?
Differentiate between sessions and batches?
Informatica Checkpoints