Answer Posted / guest
SCD 2 is coplex mapping
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
How would you join a node to the already existing domain?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
without table how to come first record only in oracle?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to load data in informatica ?
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
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What do you mean by blocking transformation?
What is flashback table ? Advance thanks
Is there any way to read the ms excel datas directly into informatica?
Differentiate between a repository server and a powerhouse?
What is InformaticaPowerCenter?
What is a sequence generator transformation?
tell me about your project functionality
