When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?

Answers were Sorted based on User's Feedback



When do we use dynamic cache and static cache in connected and unconnected lookup transformations?..

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

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?..

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

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?..

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

Post New Answer

More Informatica Interview Questions

What is rank index in rank transformation?

0 Answers  


What is meant by LDAP users?

0 Answers  


what is INFORMATICA TESTING process

0 Answers  


How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  


How do you handle decimal places while importing a flatfile into informatica?

1 Answers  


If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,


If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  


waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,


I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,


complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,


Roles and Responsibilties of Informatica Production Support Member?

6 Answers  


Enlist the differences between database and data warehouse.

0 Answers  


Categories