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

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  


What can we do to improve the performance of informatica aggregator transformation?

0 Answers  


Mapplets can you use an active transformation in a mapplet,

1 Answers  


Why union transformation is an active transformation?

0 Answers   Informatica,


what is diffrence b/w joner and union transfermation

6 Answers  


who to split dimentions into sub dimention

3 Answers   Wipro,


How many numbers of sessions can one group in batches?

0 Answers  


in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,


My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,


i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,


diffrence between command task and control task

1 Answers   iNautix,


Categories