WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE
FIELD
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kiran
Hai..,
This is Kiran.
In SCD's type we r using change capture and transfernar
stage.
date fields are using in target level as Eff_start_date and
Eff_end_date.
Eff_start_date=current date
Eff_end_date =Currentdate-1.
If any mail me
Regards
Kiran
9393363309
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / p.ganesh
SCD 2 TYPE IS USED TO MAINTAIN CURRENT AND HISTORICAL
DATA,FOR THAT I CAN USED LOOKUP,TRANSFORMER,FILTER AND STORE
PROCEDURE STAGES.FOR DATE FIELD WE CAN SELECT THE CURRENT
TIMESTAMP IN FUNTIONS IN THE TRANSFORMER STAGE.
SF--LOOKUP--TRANSFORMER/FILTER1--STOREPROCEDURE--TRANSFOR--TGT
| \FILTER2--STOREPROCEDURE--TRANSFOR--TGT
RDBMS
\FILTER3--TARGER
STOREPROCEDURE IS USED FOR GENERATE THE SID VALUES.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / pavani
scd type 2 stage used for the maintain the history,why we
are using the date function is that record is presently
record or past record identification purpose so for the past
record end_date is present record start_date these date
function used in tranformer stage.in this tranformer we
append 2 new coloumns that column names are start_date&
end_date as per my knowledge
this is pavani.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sai
by using change capture and change apply stages we can do
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rajeshchunduri
in datastage 8.0.1 version we have a stage scd.
give new data i/p link to scd stage and old data link to
transformer and from transformer give it to scd. from scd we
ger to o/p links one is fact and other is dimension.now
update date comes to dimension table.
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / swetha
Basically scd type2 used for mantain the history.
so we use the stages are Change Capture Stage,Transformer
Stage,Join Stage and we have to generate once sequence
generator and one stored procedure,remove duplicate stage.
Is This Answer Correct ? | 0 Yes | 2 No |
If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
when we have to go for a sequential file stage & for a dataset in datastage?
Differentiate between hash file and sequential file?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Differentiate between operational datastage (ods) and data warehouse?
Difference between server jobs & parallel jobs?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
What are the partition techniques available in your last project?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are the different type of jobs in datastage?
How a source file is populated?