Interested to Buy Any Domain ? << Click Here >> for more details...
Explain briefly scd type2 in datastage7.5x2(parallel)
- 1 Answers
- 6034 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 |
What is the default execution order of the sequential file?
Name the third party tools that can be used in datastage?
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
Why we use parameters instead of hard code in datastage.
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
what is the main differences between Lookup, Join and Merge stages?
What is the use of surrogate key stage?
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
Differentiate between validated and Compiled in the Datastage?
what is materialized view used datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is a quality stage in datastage tool?
Teradata 
