When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
Answer Posted / 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 |
Post New Answer View All Answers
How to go to the older version for a mapping?
What is source qualifier transformation in informatica?
What is depict expression change?
What the difference is between a database, a data warehouse and a data mart?
How to use procedural logic inside infromatica?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
In development project what is the process to follow for an etl developer from day1
how tokens will generate?
tell me about your project functionality
What is data caches/ index caches?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is the need of etl tools?
What is the fact table?
What are the uses of etl tools?