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
What are the different transaction levels available in transaction control transformation?
Different sorts of metadata that stores in the storage facility?
without table how to come first record only in oracle?
What is workflow? What are the components of workflow manager?
What is informatica etl tool?
Tell me about Propagate functions in informatica
what is size of u r database?
Can we override a native sql query within informatica?
update strategy transformation in informatica
how to load rows into fact table in data warehouse
What are the types of caches in lookup? Explain them.
What is the function of union transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Partition, what happens if the specified key range is shorter and longer
What is a joiner transformation and why it is an active one?