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 rank index in rank transformation?
What is meant by LDAP users?
what is INFORMATICA TESTING process
How can we integrate different flat file data in a single mapping and with in a single execution
How do you handle decimal places while importing a flatfile into informatica?
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?
If u select groupby port in aggregator what is output and dont select groupby option what is output
waht type of interface is used for testing the data in informatica
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?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Roles and Responsibilties of Informatica Production Support Member?
Enlist the differences between database and data warehouse.