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 |
What is the need for an etl tool?
What is informatica powercenter repository?
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
What is the difference between a repository server and a powerhouse?
Could any one to tell Fact table Partitioning?
What is difference macros and prompts?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
what are the real time problems generally come up while doing or running mapping or any transformation?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
After we make a folder shared can it be reversed?Why?
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
How we will implement Pushdown Optimization and Types in Informatica with better examples