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 main use of mapplet?
What is a shortcut and copy in Informatica and how two are different with each other?
What are roles and groups and benefits of using them?
What is meant by a domain?
What are mapplets?
What is expression transformation?
How to use pmcmd utility command?
What is meant by incremental aggregation?
How to load data in informatica ?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
According to his methodology what all you need before you build a datawarehouse
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is joiner transformation in informatica?
What are Dimensional table?
Differences between connected and unconnected lookup?