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
Differentiate between reusable transformation and mapplet.
Briefly explain the aggregator transformation?
What is rank transformation in informatica
What is the Process to creating lookup transformation in informatica
What are the new features of informatica 9.x developer?
How can you define user defied event?
Can informatica load heterogeneous targets from heterogeneous sources?
How can we delete duplicate rows from flat files?
State the differences between sql override and lookup override?
What is the status code in stored procedure transformation?
What are ETL Tools?
Mention few power centre client applications with their basic purpose?
Clarify the utilization of aggregator cache record?
What are the different lookup cache(s)?
How to load a Dimension ? and how to load a fact table?