Please explain me the difference between 3 types of slowly
changing dimension in datawarehousing?
Answer Posted / rameshgoud
scd1-> with this process we can maintain only updated data,
for ex- if a record inserted in source then the same record
should be inserted in targer, if a record updated in the
source then same update should process in target, so here
we cant maintain the history
scd2->with this we can maintain current data and complete
historical data by adding the start_date and end_date of
the records in the target table. If a records get updated
in the source same record will insert in the target as new
record and the old record is updated with end date as
todays date. Like wise we there will no be any deletion of
records, so we can maintain the compelte history here.
scd3-> using this we can maintain current and recent
historical data only
for every source possible changing column we need two
target columns as NEW_COLUMN indicates current data and
OLD_COLUMN indicates recent historical data
when a new record getting loaded source data is always
loded in NEW_COLUMN in target
when a record is midified target NEW_COLUMN is updated in
target OLD_COLUMN and source data is updated in target
NEW_COLUMN.
Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
What is size of a transaction and an array means in a datastage?
How to perform incremental load in datastage?
What are some different alternative commands associated with "dsjob"?
What is datastage?
Define project in datastage?
What is the sortmerge collector?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the some differences between 7.x and 8.x version of datastage?
client know skid info?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What are the components of ascential data stage?
To see hidden files in LINIX?
What are the types of jobs we have in datastage?
How can we improve the performance in datastage?
What could be a data source system?