Interested to Buy Any Domain ? << Click Here >> for more details...
When will you use SQL override in a lookup transformation?
- 1 Answers
- 5757 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
How can you validate all mappings in the repository simultaneously?
Explain the difference between a data warehouse and a data mart?
What is the need of an ETL tool?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Is it possible to revert a global repository to local one and why?
What is the need for an etl tool?
How many types of sessions are there in informatica.please explain them?
How to differentiate between the active and passive transformations?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is a joiner transformation and why it is an active one?
what is song in infrmatica...?
What you know about transaction control transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
Which transformation should we use to normalise the COBOL and relational sources?
