when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.
Answer / 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 |
How to generate sequence numbers using expression transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What if the source is a flat-file?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
How can a transformation be made reusable?
What are the types of error logs available in Informatica?
What is a filter transformation and why it is an active one?
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
How can you increase the performance in joiner transformation?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
What is the Difference between SetVariable and setmaxvariable in informatica?