Answered Questions

  • What is job commit in Datastage?

    What is job commit in Datastage? If I am working on parallel jobs, how can I give this option(in each odbc satge) that commit should perform after specific number of records transaction. Please help

    RAJESH

    • Sep 11th, 2011

    Read Committed and arraysize u option in target ODBC stage.

    Venkat Duvvuri

    • Sep 9th, 2011

    Hi Im not sure which version of datastage you r using..this is pretty much simple in Datastage8.5 by using DTS

    Thanks n Regards
    Venkat Duvvuri

  • Datastage Job Scenario question

    input file A contains12345678910input file B contains6789101112131415Output file X contains12345Output file y contains678910Output file z contains1112131415How can we do in this in a single ds job in px ?....could you please give me the logic to implement ???

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: vinod chowdary

    • Jul 28th, 2011


    Hello guy's, I would like to solve this by using the Change capture stage. First, i am going to use source as A and refrerence as B both of them are connected to Change capture stage. From, change capture stage it connected to filter stage and then targets X,Y and Z. In the filter stage: keychange column=2 it goes to X [1,2,3,4,5] Keychange column=0 it goes to Y [6,7,8,9,10] Keychange column=1 it goes to Z [11,12,13,14,15] Revert me PLz

    Priya Ranjan kumar

    • Aug 28th, 2017

    You can solve this question in easily way like.
    First use the funnel to take the input data from different sources and used check box for unique data(No duplicate data) then
    you can use transformer where you can apply logic like. @INROW

    Pavan Kumar

    • Jul 30th, 2015

    Using change capture stage:

    File1(Master),File2----> change capture---> Filter ---->
    T1, T2, T3
    In Filter,
    Change_code=1 then send then to T1-->(Insert records)
    Change_code=0 then send then to T2-->(Copy records)
    Change_code=2 then send then to T3-->(Delete records)

  • Sequencer Scenario

    scenario- if suppose we have 3 jobs in sequencer, while running if job1 is failed then we have to run job2 and job 3 ,how we can run? plz ans this thanks in advance

    Gopi N

    • Jul 11th, 2012

    If the scenario we have like 1st is abort and then trigger 2nd and 3rd do the below, give the trigger condition like, 1> If job aborted give the link trigger condition which is going to 2nd and 3rd j...