WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE
FIELD

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Whats difference betweeen operational data stage (ods) and data warehouse?

670


What are the types of containers?

688


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1631


If you want to use a same piece of code in different jobs, how will you achieve this?

795


How to perform incremental load in datastage?

668






What are some different alternative commands associated with "dsjob"?

653


What is the difference between datastage and datastage tx?

598


What could be a data source system?

579


how do u catch bad rows from OCI stage? And what CLI stands for?

2288


Differentiate between datastage and datastage tx?

599


what is 'reconsideration error' and how can i respond to this error and how to debug this

2120


describe the Steps to confiure a Qlogic switch

1937


Define ds designer?

766


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?

1047


Highlight the main features of datastage?

615