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

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

Question Posted / brahmaiah.dwh

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

Answer / 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

More Informatica Interview Questions

What differs when we choose the sorted input for aggregator transformation?

If I am having 6 flat files in data. How can you load the data at a time

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

if we have a delimiters at unwanted places in a flat file how can we over come those.

what is the drillup & drill down?and use of the drill up and drill down?

Enlist the differences between database and data warehouse.

what is datamart

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

what is normalizer transformation?

what is the command to get the list of files in a directory in unix?

Difference Between ETL & ELT?

How to partition the Session?

For more Informatica Interview Questions Click Here