Submitted Questions

  • Ways of implementing scd2

    How many number of ways that you can implement SCD2 ? Explain them

    RAJESH

    • Aug 1st, 2011

    3 ways to construct the scd2 in datastage 8.0.1
    1)using SCD stage in processing stage
    2)using change capture and change applay stages
    3)using source file,lookup,transformers,filters,surrogate key generator or stored procedures,target tables