How do you create single lookup transformation using
multiple tables?
Answer Posted / bsgsr
join the tables in the database itself then do the look up
else override the lookup sql and look up.
i believe this would work.
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What are the different lookup cache(s)?
What are the features of complex mapping?
What differs when we choose the sorted input for aggregator transformation?
Explain your project of banking domian.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are roles and groups and benefits of using them?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are batches?
Where can we find the throughput option in informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the components of the workflow manager?
Can you generate sequence numbers without using the sequence generator transformation?
How do you migrate data from one environment to another?
wat are deployement groups in informatica, how it will be used for developers