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


Please Help Members By Posting Answers For Below Questions

What is the reusable transformation?

621


where to store informatica rejected data? How to extract the informatica rejected data?

597


Name at least 5 different types of transformations used in mapping design and state the use of each.?

666


What is meant by lookup transformation? Explain the types of lookup transformation?

565


Why filter transformation is an active one?

559






Performance tuning( what you did in performance tuning)

1483


In warehouses how many schemas are there?

577


What do you mean by channel change?

535


How do you load unique records into one target table and duplicate records into a different target table?

697


What is the use of code page?

601


How to convert multiple rows to single row (multiple columns) in informatica

888


What all join we can perform in LOOKUP transformation?

559


Partition, what happens if the specified key range is shorter and longer

2027


Under what conditions selecting sorted input in aggregator will still not boost session performance?

628


What is expression transformation?

625