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 create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is lookup transformation?
What is blocking transformation?
Mention a few design and development best practices for informatica?
Why sorter is an active transformation?
what is the size of u r source(like file or table)?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is an expression transformation?
What are active and passive transformations?
Difference between Data and Index Caches?
In development project what is the process to follow for an etl developer from day1
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is target designer and target load order?
How are indexes created after completing the load process?