Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / priya
look up transformation is used to look the data either from
source or target whenever the req feild is not in the
mapping.
we can use two or more tables as look up by using the join
condition
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is aggregator transformation in informatica?
Repository user profiles
What are the tasks that source qualifier perform?
What are the types of data warehouses?
Name the different lookup cache(s)?
What are connected or unconnected transformations?
What is transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Write the unconnected lookup syntax?
what is the hint? how to use it to reduce the query processing in program?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How can you differentiate between powercenter and power map?
What is confirmed fact in dataware housing?
Difference between Data and Index Caches?
