How do you create single lookup transformation using
multiple tables?
Answer Posted / koti
Re: How do you create single lookup transformation using
multiple tables?
Answer
# 1 Lookup transformation: Based upon one/more keys the
data is
retreived from one/more tables.
create a single lookup transformation by Joining the
multiple tables, having connected the keys defined in
lookup tranformation.
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
What is the advantage of informatica?
What is meant by LDAP users?
How do you migrate data from one environment to another?
What is a router transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is a repository manager?
What is meant by a domain?
How can we remove the duplicates from flat file source?
Informatica Checkpoints
What are the transformations that are not supported in mapplet?
What are session parameters ? How do you set them?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is target load order?
What are data-driven sessions?