When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
Answer Posted / vinod saini
Dynamic cache uses for updation of Master Table & SCD type 1
Static uses for Flatfile
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Where can we find the throughput option in informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Target increases every day even though no new record was inserted
How do you load alternate records into different tables through mapping flow?
what is the Default Source Option For Update Strategy Transformation?
Explain lookup transformation in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain pushdown optimization $pushdownconfig parameter - informatica
server hot-ws270 is connect to Repository B. What does it mean?
What is main use of mapplet?
What is persistent lookup cache?
What is an unconnected transformation?
In informatics server which files are created during the session rums?
Explain Dataware house architecture .how data flow from intial to end?
Describe the impact of several join conditions and join order in a joiner transformation?