When we are using Dynamic Cache,which options we will select
in session level?

Answer Posted / ankit

You need to select "Dynamic lookup cache" property in session and also select either "Inser else update" or "update else insert".

Thanks,
Ankit

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1862


What are the differences between oltp and olap?

542


What is meant by pre and post session shell command?

610


Mention few power centre client applications with their basic purpose?

525


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1599






Under what conditions selecting sorted input in aggregator will still not boost session performance?

625


How to load data in informatica ?

561


What is the meaning of decode in informatica?

642


What is workflow? What are the components of the workflow manager?

629


Briefly explain the aggregator transformation?

584


What is option by which we can run all the sessions in a batch simultaneously?

657


Define sessions in informatica etl?

609


have u done any performance tuning? how u ll do?

1851


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1175


expain about the tune parameters?

1873