Answered Questions

  • Multiple files and output

    I have two files target 3 files file no1: 1 2 3 4 file2 3 4 5 6 output like first file 1,2 first file 3,4 second file 5 ,6 3rd file target how to achieve this


    • Jul 14th, 2017

    First copy the value from your seq. file using "copy stage", then use "funnel stage" to join the two seq. file, then sort them and use "remove duplicate stage" to find the duplicate values (eg: 3,4) t...


    • Jul 28th, 2015

    Basically Question is about how you will achive Left Join, Inner Join and Outer Join.

  • Datastage scenario Question

    A Sequences is calling activity 1, activity 2 and activity 3.while running, activity 1 and 2 got finished but 3 got aborted. How can I design a sequence such that the sequence has to run from activity 2 when I restart the sequences?


    • Apr 21st, 2014

    You have to check the " Do not checkpoint run " checkbox for activity 2. If you set the checkbox for a job that job will be run if any of the job later in the sequence fails and the sequence is restarted.

  • Datastage job scenario question

    My input has a unique column-id with the values 10,20, can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?


    • Nov 25th, 2018

    If your output file is sequential file then you can you use filter property .


    • Nov 25th, 2018

    If the input has 2 partion then i would get 2 rows for lastrow() function. rest everyhing is correct

  • 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 27th, 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)