Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE
FIELD
- 8 Answers
- 22604 Views
- L&T, I also Faced
- E-Mail Answers
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
Lookup constraints
What is the difference between an operational datastage and a data warehouse?
Can you explain kafka connector?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is the difference between account and directory options ?
How do y read Sequential file from job control?
Describe the main features of datastage?
How will you move hashed file from one location to another location?
What are the various kinds of containers available in datastage?
How can one find bugs in job sequence?
Is the value of staging variable stored temporarily or permanently?
What is the difference between validated and compiled in the datastage?
What are the different options associated with dsjob command?
What are the types of containers?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
