Explain briefly scd type2 in datastage7.5x2(parallel)
- 1 Answers
- 5281 Views
- IBM, I also Faced
- E-Mail Answers
scd2: slowly changing dimension 2
SCD2 is used to maintain both current data and historical
data.
for ex: If we are having following data
cid cname city country
101 raju hyderabad India
if we want to implement scd2 for the above data we need to
create target table with columns
scid cname city country flag version date
scid - surrogate key column
and if the customer moves from hyderabad to delhi then the
output will be
scid cname city country flag version
1 raju hyderabad India 0 1
2 raju delhi India 1 2
Flag = 0 defines historical data
Flag = 1 defines current data
Similarly if again raju moves from delhi to mumbai the the
output will be
scid cname city country flag version
1 raju hyderabad India 0 1
2 raju delhi India 0 2
2 raju mumbai India 1 3
n so on..
| Is This Answer Correct ? | 4 Yes | 0 No |
How can we improve the performance in datastage?
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
Give an idea of system variables.
What is the command line function to import and export the ds jobs?
How to convert table data into xml file using xml output stage? please explain step by step;
How can remove duplicates in a file using UNIX?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
How to remove duplicates in transformer stage? in parallel mode
State the difference between an operational datastage and a data warehouse?
what is snow flack schema?
what is main difference between change capture and change apply stages
What are the components of datastage?
Teradata 
