When will you use SQL override in a lookup transformation?
Answer Posted / vanita
For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is sequence generator transformation in informatica?
How does a sorter cache works?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Global and Local shortcuts. Advantages.
Explain in detail scd type 2 through mapping.
How to update source definition?
How to improve the performance of a session using sorter transformation?
Explain the scenario which compels informatica server to reject files?
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?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are the different lookup cache(s)?
What does reusable transformation mean?
Partition, what happens if the specified key range is shorter and longer
What is a node in Informatica?
What are the differences between oltp and olap?