Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,


How we can create indexes after completing the load process?

0 Answers  


IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  


a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,


following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,






Briefly define a session task?

0 Answers  


What is a connected transformation?

0 Answers   Informatica,


what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,


how can import the data from the flat files?

2 Answers  


Difference Between ETL & ELT?

1 Answers   TCS,


What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,


What is event and what are the tasks related to it?

0 Answers  






Categories