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
Explain pmcmd command usage in informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is domain in terms of informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain the aggregator transformation?
difference between repository database and repository service?
draw informatica architecture 8.6 ?
What is the surrogate key?
What are the transformations that are not supported in mapplet?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is informatica powercenter repository?
How to use pmcmd utility command?
What is the use of an aggregator cache file?