Explain briefly scd type2 in datastage7.5x2(parallel)
Answer Posted / pranay
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 |
Post New Answer View All Answers
what is use of SDR function?
Can we use target hash file as a lookup ?
How to convert RGB Value to Hexadecimal values in datastage?
Can you highlight the main features of ibm infosphere information server?
Can you explain players in datastage?
Difference between data warehousing and olap?
What are the important features of datastage?
What is ibm datastage flow designer?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is difference between join, merge and lookup stage?
What are the functionalities of link collector?
What are the job parameters?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
If you want to use the same piece of code in different jobs, how will you achieve it?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name