explain how to create SCD-2 IN DATASTAGE 7.5X2
PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE
AND JOB DESINGN URGENT
Answer Posted / guest
Dim_table
change capture xfm
Src_table
Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Explain entity, attribute and relationship in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How do you generate sequence number in datastage?
options available in sequence job to run,validate?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are routines in datastage?
What is the use of datastage director?
Why do we use exception activity in Datastage?
What are the job parameters?
What is meta stage?
What is the process of killing a job in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
Why we use surrogate key?
What is size of a transaction and an array means in a datastage?