In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?



In Lookup transformation a sql override should be done and disable the cache how do you do this pr..

Answer / 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

More Informatica Interview Questions

what happens when a batch fails?

3 Answers  


Why union transformation is an active transformation?

0 Answers   Informatica,


when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,


Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,


Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,






How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,


How many transformations can be used in mapplets.

0 Answers  


What is a design?

1 Answers  


What does cheating measurement mean?

0 Answers  


can we create index and drop index in exsisting table while using infomatica

4 Answers  


What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,


Categories