How do you create single lookup transformation using
multiple tables?
Answer Posted / latha
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 ? | 10 Yes | 8 No |
Post New Answer View All Answers
How can you validate all mappings in the repository simultaneously?
What is workflow manager?
How can we remove the duplicates from flat file source?
How to update a particular record in target with out running whole workflow?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
In which transformation you cannot drag ports into it?
What is informatica?
Can you generate sequence numbers without using the sequence generator transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
can anyone explain me about retail domain project in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
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. ?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the mapping parameters and mapping variables?