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
Explain the tuning lookup transformation - informatica
What is the need of an ETL tool?
How to start a workflow using pmcmd command?
Explain target update override in informatica
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the maplet?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Different qualification between a related rotate toward the sky and isolates look upward?
What is joiner change?
What is a router transformation?
How can a transformation be made reusable?
What is aggregator transformation in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Global and Local shortcuts. Advantages.