When will you use SQL override in a lookup transformation?
- 1 Answers
- 5376 Views
- I also Faced
- E-Mail Answers
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
Explain lookup transformation in informatica
Explain sessions?
Have you worked with/created Parameter file
What are the differences between joiner transformation and source qualifier transformation?
What are ETL Tools?
What are mapplets? How is it different from a Reusable Transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
How can a transformation be made reusable?
Can you generate sequence numbers without using the sequence generator transformation?
What are pre and post-session shell commands?
Clarify the aggregator change?
What are the differences between source qualifier and joiner transformation?
What do you mean by enterprise data warehousing?
How many dimensions are there in informatica?
How do you load alternate records into different tables through mapping flow?
