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
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is an Integration service in Informatica?
Explain sessions and how many types of sessions are there?
What is the difference between informatica 7.0 and 8.0?
What are data-driven sessions?
How can you generate reports in informatica?
How to open an older version of an object in the workspace?
Explain Dataware house architecture .how data flow from intial to end?
Differentiate between a repository server and a powerhouse?
How to convert multiple rows to single row (multiple columns) in informatica
How you can differentiate between connected lookup and unconnected lookup?
What is an unconnected transformation?
What is the benefit of session partitioning?
How to do unit testing in informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?