one source to target loading insert new rows and update
existing rows?
Answer Posted / ppl
using scd type 2 v can do dis
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the different types of olap? Give an example?
What are the designer tools for creating transformations?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Where is metadata stored?
What are multi-group transformations?
What is an expression transformation in informatica?
What is update strategy transform?
What is the difference between router and filter?
What is fact table? Explain the different kinds of facts.
What is the difference between a repository server and a powerhouse?
how many types of dimensions are available in informatica?
How to partition the Session?
Difference between Data and Index Caches?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?