Answered Questions

  • Splitting a Large Job DataStage into Smaller Jobs

    What is the process to split the large datastage job into smaller jobs?

    Rohit

    • Oct 16th, 2015

    If there is a job having more no of stages say around 20 stages. Then generate the output to an intermediate file like a dataset using the first 10 stages. After generating this use this intermediate dataset to comibine with the remaining stages and then generate the final file

  • Single column with multiple rows should be converted into single row with commas

    Can any one help.... Source is..... a b c d want target as..... a,b,c,d thanks in advance

    preeti

    • Aug 9th, 2017

    You can create a other array with some size and insert data in single array from double array for more see the following code for(int i=0;i

    Code
    1. class TestClass{
    2.           public static void main(String l[])
    3.           {
    4.                   int [][]a={{1},{2},{3},{4},{5}};
    5.                   int a1[]=new int[6];
    6.                   int k=0;
    7.                   for(int i=0;i<a.length;i++)
    8.                   {
    9.                           for(int j=0;j<a[i].length;j++)
    10.                           {
    11.                                  
    12.                                
    13.                                   a1[k]=a[i][j];
    14.                                   k++;
    15.                                 System.out.println(a[i][j]);
    16.                           }
    17.                          
    18.                   }
    19.                  
    20.          
    21.        
    22.  for(int i=0;i<a1.length;i++)
    23.  {
    24.         System.out.print(a1[i]);
    25.  }
    26.           }
    27.  
    28.  }

  • convert multiple rows into single row

    hi... i have sourse like name,city johny,newyork johny,mumbai johny,del want output like..... name,city1,city2,city3 johny,nework,mumbai,delhi ----------------------------------------- thanks in advance...

    RAM

    • Aug 27th, 2015

    Without using Pivot stage..
    Source --> COPY
    COPY --> Head(1) --> File1
    COPY --> Head(2) -->Tail(1) --> File2
    COPY --> Tail(1)-->File3
    now merge all file1,file2,file3 --> Target.
    Pls check it may work.