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 can we use batches?

0 Answers  


how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  


Two different admin users created for repository are ______ and_______

1 Answers  


When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  


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?

8 Answers   BRAD, TCS,






what is mapping performence?

2 Answers   Cap Gemini,


What are the types of schemas we have in data warehouse.

0 Answers  


How to get EVEN & ODD numbers separately?

8 Answers  


8.what is mapplet ?give example?

2 Answers  


When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  


create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

0 Answers   Patni,


Categories