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 is mystery dimension?

1 Answers  


What is the maplet?

0 Answers   Informatica,


What is the difference between a repository server and a powerhouse?

0 Answers  


What is the difference between informatica 7.0 and 8.0?

0 Answers  


I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,






Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,


TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,


How to partition the Session?

0 Answers   Informatica,


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

1 Answers   Cognizant,


Where do we use mapping variables in informatica?

0 Answers  


how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  


Categories