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
scenario where i can use only concurrent execution of workflow.
Make a note of the quantity vaults made in informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is a sequence generator transformation?
How to use procedural logic inside infromatica?
What is a router transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to update or delete the rows in a target, which do not have key fields?
Why union transformation is an active transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
how to load dimension table and fact table. plz tell me the steps.
how many types of dimensions are available in informatica?
What are the new features of informatica 9.x in developer level?
Different qualification between a related rotate toward the sky and isolates look upward?
what are the deliverables?in your project?