When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
- 3 Answers
- 11962 Views
- I also Faced
- E-Mail Answers
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 |
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
why normalizer transformation can not used in mapplet? plzzzz answer
How/where can i install Informatica software with oracle or teradata as database
What is complex mapping?
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
What are the databases that informatica can connect to windows?
Can we combine a flatfile and a database table using an UNION transformation?
How does the server recognize the source and target databases. Elaborate on this.
4 yrs etl devloper roles and responsibilities?any body give solutions
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How do you load only null records into target? Explain through mapping flow.
Can yoU use the maping parameters or variables created in one maping into another maping?
Teradata 
