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
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Explain entity, attribute and relationship in datastage?
Where do you see different stages in the designer?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the steps needed to create a simple basic datastage job?
What are system variables and sequencers in datastage
how to add a new records into source?
Describe routines in datastage? Enlist various types of routines.
What are orabulk and bcp stages?
What are the types of containers and how to create them?
How many types of sorting methods are available in datastage?
On which Dimension Table you implemented SCD Type in your Project
What is the use of datastage director?
What are the some differences between 7.x and 8.x version of datastage?
What is the difference between account and directory options ?