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 can we load starting with 11th record of a table from source to target
What are differences between Informatica 7.1 and 6.1
how we can do session partition in informatica any one explain me clearly? thanks advance.
What is a mapplet/worklet in informatica?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
what transformations are used for Variable port?
Why we use lookup transformations?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
What is a pre-defined event and user-defined event?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?