Interested to Buy Any Domain ? << Click Here >> for more details...
How do you create single lookup transformation using
multiple tables?
- 6 Answers
- 44859 Views
- TCS, I also Faced
- E-Mail Answers
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 ? | 43 Yes | 2 No |
Post New Answer View All Answers
What do you understand by SOA of Informatica?
What does role playing dimension mean?
Tell me about Propagate functions in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How can we remove the duplicates from flat file source?
how tokens will generate?
What is dimensional table? Explain the different dimensions.
Which transformation is needed while using the Cobol sources as source definitions?
What do you mean incremental aggregation?
Sequence generator, when you move from develoment to production how will you reset
Why do you use Mapping Parameter and mapping variable?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is the commit type if you have a transaction control transformation in the mapping?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
