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

Answer Posted / bprathap4u

Session will be failed with following error message

Message Code: CMN_1254
Message: ERROR: Feature not yet supported: [Lookup override
with caching off]

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features of informatica 9.x in developer level?

759


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1354


What is a sequence generator transformation?

758


How many number of sessions can one group in batches?

889


what is degenerated dimension?

3484


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1833


What is blocking transformation?

911


How to update a particular record in target with out running whole workflow?

1343


What is a filter transformation?

793


How would you copy the content of one repository to another repository?

755


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

828


How can we use mapping variables in informatica?

776


Explain the difference between mapping parameter and mapping variable?

793


What are the reusable transformations?

868


What are batches?

806