How do you create single lookup transformation using
multiple tables?
Answer Posted / kalyan
we have the lOOKUP OVERRIDE Query in the Lookup
transformation. Use the SQl Query to join the tables you
lookup on. Thsi is similar to what yo do at the Source
Qualifier
Is This Answer Correct ? | 42 Yes | 2 No |
Post New Answer View All Answers
What is persistent lookup cache?
Why update strategy and union transformations are active?
What is session task and command task?
How can you define user defied event?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Differentiate between a repository server and a powerhouse?
Can we override a native sql query within informatica?
How to create the source and target database connections in server manager?
How do you set a varible in incremental aggregation
State the differences between sql override and lookup override?
Tell me about MD5 functions in informatica
differences between service based and product based?
What are the tasks that source qualifier perform?
Mention few advantages of router transformation over filter transformation.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?