In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
Answer Posted / sukanta
The interviewer just check your knowledge about Informatica
Lookup Transformation.
If you disable cache you can't override the default sql query.
Follow Informatica Help.
Regards
Sukanta
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Explain the informatica workflow?
What are the components of Informatica? And what is the purpose of each?
How can we create index after completion of load process?
Suppose we do not group by on any ports of the aggregator what will be the output?
How to update or delete the rows in a target, which do not have key fields?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the use of source qualifier?
What if the source is a flat-file?
What are the informatica performance improvement tips
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How can we delete duplicate rows from flat files?
Repository user profiles
What is the Process to creating lookup transformation in informatica
What is a node in Informatica?
how we can load rejected record's at run time?(not through bad files)