Please explain me the difference between 3 types of slowly
changing dimension in datawarehousing?
Answer Posted / venkatesh.m
scd1 ---->will contain only the updated data(ie it contains
the newly entered data + updates of historic data)it dose
not maintain historic data
scd2 ---->it contains the updated data and the historic data
(full history)
scd3 ----->it contains updated data and historic data
partially(means it may contain the records of the last
6months i think)
Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
What is usage analysis in datastage?
What is orabulk stage?
Nls stands for what in datastage?
project Steps,hits, Project level HArd things,Solved methods?
Which commands are used to import and export the datastage jobs?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the components of datastage?
What is "fatal error/rdbms code 3996" error?
What is difference between symmetric multiprocessing and massive parallel processing?
What is a folder? Difference types of stages?
What are routines in datastage? Enlist various types of routines.
What are the types of hashed files in data stage
What are the primary usages of datastage tool?
What are stage variables, derivations and constants?