Technical Discussion :: Informatica
Home > Technical Interview Q&A > Informatica > Discussion
6. Why scd2? can we do insert update in scd1 and how?(what if we have a new record and our mapping is scd1)
Answer:
SCD2 allow keep the current and historical data in table.
SCD1 allows keep only current data. Not the historical data.
can we do insert update in scd1 and how?
Ans: Yes SC|D1 allows to insert update in data.
Anonymous
31 Mar, 2018 4:19 AM
SCD2 allow keep the current and historical data in table.
SCD1 allows keep only current data. Not the historical data.
can we do insert update in scd1 and how?
Ans: Yes SC|D1 allows to insert update in data.
