WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE
FIELD
Answer Posted / praveen kumar
Hai this is praveen kumar yenduri,
from my knowledge.....
in SlowlyChangingDimension ---type 2
we use the stages are Chance Capture Stage,Transformer
Stage,Join Stage and we have to generate once sequence
generator and one stored procedure......
As kiran said he explains only the half of the topic..
the concept is....
the SCD-type2 means...when ever the record is
inserted,updated,deleted...the target table had to be get
updated everytime....that the thing for this case...
we have to use the change capture stage..when using change
capture stage it takes 2 inputs..one is target RDBMS,second
one is Recent RDBMS,as defining the target one as "before"
link and source..ie.,recent as "after"...from that we can
have some change codes ...basing on that codes we can
perform the operations...after getting the change codes...it
had to send to transformer stage their basing upon the codes
the stored procedures had to taken...thats the topic
goes...once you get the idea you can do it....
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Define Routines and their types?
Define Merge?
What is the importance of the exception activity in datastage?
How do you reject records in a transformer?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Demonstrate experience in maintaining quality process standards?
How do you schedule or monitoring the job?
Explain connectivity between datastage with datasources?
What is use Array size in datastage
What are iconv and oconv?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Notification Activity
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Difference between server jobs & parallel jobs?
Distinguish between informatica & datastage. Which one would you choose and why?