when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.
Answer Posted / swapna
static cache is used when the records in the source does not update more frequently.
dynamic cache is used when the records in the source frequently updates.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the size of your data warehousing?
How do we call shell scripts from informatica?
How to convert multiple rows to single row (multiple columns) in informatica
Enlist the tasks for which source qualifier transformation is used.
Describe data concatenation?
Do you find any difficulty while working with flat files as source and target?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How might one distinguish in the case of mapping is right or not without associating session?
What is the difference between stop and abort in informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain why we use partitioning the session in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How can we remove the duplicates from flat file source?