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 is the reusable transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is meant by lookup transformation? Explain the types of lookup transformation?
Why filter transformation is an active one?
Performance tuning( what you did in performance tuning)
In warehouses how many schemas are there?
What do you mean by channel change?
How do you load unique records into one target table and duplicate records into a different target table?
What is the use of code page?
How to convert multiple rows to single row (multiple columns) in informatica
What all join we can perform in LOOKUP transformation?
Partition, what happens if the specified key range is shorter and longer
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is expression transformation?