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....

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

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.

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.

Answer / sai

by using change capture and change apply stages we can do

Answer / suneel

Hi Praveen Kumar yenduri,

can u explain deeply, why u using TX, join and stored procedures in this job.
what is the need of these stages.. please explain me.

Thanks.

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.

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.

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers   IBM, Polaris,

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

How to find value from a column in a dataset?

0 Answers   TIAA CREF,

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers  

how to define satge variables in transformer stage

2 Answers  

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

how to create document in datastage?

1 Answers   Cap Gemini,

What are the important features of datastage?

0 Answers  

How to perform incremental load in datastage?

0 Answers  

What are sequencers?

0 Answers