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
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
What are the differences between oltp and olap?
What is meant by pre and post session shell command?
Mention few power centre client applications with their basic purpose?
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. ?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to load data in informatica ?
What is the meaning of decode in informatica?
What is workflow? What are the components of the workflow manager?
Briefly explain the aggregator transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Define sessions in informatica etl?
have u done any performance tuning? how u ll do?
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 ?
expain about the tune parameters?