Are there any types of Dynamic Caches in informatica
Answer Posted / pa1
Dynamic Cache is there for look up t/r. But we need to look
up only on targets
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences between source qualifier and joiner transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Design a mapping to load a target table with the following values from the above source?
What is incremental aggregation?
What is a difference between complete, stop and abort?
How do you promote a non-reusable transformation to reusable transformation?
Why filter transformation is an active one?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is a mapplet/worklet in informatica?
What is the difference between a connected look up and unconnected lookup?
Describe an informatica powercenter?
What are the tuning techniques you applied during your last project
what are factless facts? And in which scenario will you use such kinds of fact tables.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?