When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / veera
When/Under what circumstances do we use dynamic and static
cache in connected
lookup?
When/Under what circumstances do we use static cache in
unconnected lookup?
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / bc
we can use dynamic and static cache in connected
lookup..and we can use only static cache in unconnected
lookup.
| Is This Answer Correct ? | 0 Yes | 4 No |
How we can create indexes after completing the load process?
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
How do you manage the Parameter files while migrating your data from one environment to another environment?
explain abt union t/r?
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
how we can do session partition in informatica any one explain me clearly? thanks advance.
Can we update a target table (without primarykey) by using update strategy transformation?
Why we select the table which has minimum number of records as Master table in joiner?
Explain Dataware house architecture .how data flow from intial to end?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
In which scenario did u used Mapping variable?
What the difference is between a database, a data warehouse and a data mart?