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


Please Help Members By Posting Answers For Below Questions

What is the benefit of session partitioning?

600


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1503


Different circumstance which drives informatica server to expel records?

556


Is it possible to define a single node as a Gateway node as well as worker node?

663


What is olap (on-line analytical processing?

647






What is data caches/ index caches?

615


What happens when a session fails and you click on recover?

659


What do you understand by SOA of Informatica?

592


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1842


Why do we need informatica?

554


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1611


Explain in detail about scd type 1 through mapping.

591


How to do the error handling of if ur source is flatfiles?

1515


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1711


Do you find any difficulty while working with flat files as source and target?

677