Explain briefly scd type2 in datastage7.5x2(parallel)
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 |
what r the sources u need to create the datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Highlight the main features of datastage?
How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.
Is possible to create skid in dim,fact tables?
What all are the different way to run a job?
Can you filter data in hashed file?
What is the use of datastage director?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
How can we select pr retrieve the particular row in dataset by using orchadmin command?