How do you create single lookup transformation using
multiple tables?
Answer Posted / bsgsr
join the tables in the database itself then do the look up
else override the lookup sql and look up.
i believe this would work.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is a mapplet/worklet in informatica?
What are the different versions of informatica?
What is the use of source qualifier?
What is a filter transformation and why it is an active one?
What is xml source qualifier transformation in informatica?
What are the tasks that source qualifier perform?
explain abt ur project architecture?
How do you promote a non-reusable transformation to reusable transformation?
What are connected or unconnected transformations?
list out all the transformations which use cache?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Define joiner transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
What are the performance considerations when working with aggregator transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?