How do you create single lookup transformation using
multiple tables?
Answer Posted / murali vishnuvajhala
you cannot join two tables in a lookup. Lookup works only
on one underlying table.
Is This Answer Correct ? | 4 Yes | 34 No |
Post New Answer View All Answers
How to load the data from a flat file into the target where the source flat file name changes daily?
What does cheating measurement mean?
What the difference is between a database, a data warehouse and a data mart?
What is workflow monitor?
What are the advantages of using informatica as an etl tool over teradata?
What are the issues you have faced in your project? How did you overcome those issues?
How does a rank transform differ from aggregator transform functions max and min?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the informatica performance improvement tips
What are batches?
What are the components of workflow manager?
Tell me about Propagate functions in informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process