Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - How to design the change capture stage in(data stage parallel jobs) type 2?




1973
views
asked mar September 20, 2014 06:33 AM  

How to design the change capture stage in(data stage parallel jobs) type 2?


           

1 Answers



 
answered By vishnoiprem   0  
Take target and source
  • Use Change capture stage to identify the changes using Existing target and Your New Source
  • You can identify edited records and inserted records with the help of change_code
  • After cdc use transformer stage
  • Using transformer functions you can handle eff_start_date,eff_end-date
  • Take the target in two steps one for updated rows and second for inserted rows 7.In 8.0 you have a stage for scd you can do scd type 2 by using that
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert