Login/RegisterTechnical Discussion :: Informatica
Home > Technical Interview Q&A > Informatica > Discussion
6 / 94
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.
Asked In ::
Data Geek
13 Oct, 2019 1:07 PM
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.
