Please explain me the difference between 3 types of slowly
changing dimension in datawarehousing?
Answer Posted / sowmi
scd 1:It wont implement the new change.It always contains
the historic data alone.
scd 2:It will replace or overwrite the existing record.It
will not contain the historic data.But it has surrogate key.
scd 3:It contains both the old data and a new record with
the modified information and has additional columns like
"effective start date and end date" or "version no".
Please correct me if i am wrong
Is This Answer Correct ? | 0 Yes | 20 No |
Post New Answer View All Answers
How a routine is called in datastage job?
What is the difference between validated and compiled in the datastage?
AGGREGATOR default datatype
How can we improve performance of data stage jobs?
table actions available in oracle connector?
What is the precedence of stage variables,derivations, and constraints?
Why fact table is in normal form?
how many rows sorted in sort stage by default in server jobs
How do you start developing a datastage project?
What are the stages in datastage?
What are the various kinds of containers available in datastage?
Define oconv () and iconv () functions in datastage?
how to sort two columns in single job in datastage.
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is apt_config in datastage?