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 |
what is the drillup & drill down?and use of the drill up and drill down?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is difference between maplet and reusable transformation?
What is up date strategy and what are the options for update strategy?
what is the look up transformation?
What is a poling?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
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.