Submitted Questions

  • 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

  • how to seperate two diff datatypes and load it into two files?

    i have a source file1 consist of two datatypes file1: no(integer) 1 2 3 & dept(char) cs it ie and i want to seperate these two datatypes and load it into target files file2 & file3. how can i do this in datastage and by using which stage?


    • Oct 10th, 2017

    So you can do it with transformer constraints like
    allnum(), alpha() like function and separate both datatypes in two different outputs

  • what are the uses of using parameters in datastage?


    • Feb 20th, 2015

    Use of parameters: 1. avoid hardcoding. 2. Incase a value for some parameter is changed in future, we can change it at a single point instead of making changes everywhere in every job wherever it is ...

    Lubna Khan

    • Jan 27th, 2014

    By Using Parameters we can avoid hardcoding and assign values at runtime