Data Integration Question:
Explain History Preserving?
Answer:
- History Preserving is for providing new row in the target instead of updating the existing row.
- The columns are indicated for transforming the changes that are to be preserved.
- New rows are created when the value of certain column changes.
- Each of these rows is flagged as UPDATE.
- The UPDATE flag is applied for the input data set.
- The columns are indicated for transforming the changes that are to be preserved.
- New rows are created when the value of certain column changes.
- Each of these rows is flagged as UPDATE.
- The UPDATE flag is applied for the input data set.
| Previous Question | Next Question |
| Explain is Data integration And ETL programming is same? | Can you explain Pivot – Columns to Rows? |