When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
- 3 Answers
- 11354 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 |
WHat all joins are there in Source Qualifier?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
where does the default group roew in a router is stored what is the default size of memory in router
How many number of sessions that u can create in a batch?
How to retrieve last two days updated records?
How do you implement unconn. Stored proc. In a mapping?
Difference between task flow and linear task flow
Design a mapping to get year of join for each employee.
Explain lookup transformation in informatica
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
How can we use mapping variables in informatica?
How to import oracle sequence into Informatica?
Teradata 
