-
Splitting a Large Job DataStage into Smaller Jobs
What is the process to split the large datastage job into smaller jobs?
-
Convert Column Data into Row Data
Solve in Datastage Input: col1, col2, col3 ---------------- a, b, c d, e, f Output like Col --- a b c d e f
-
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
-
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...
-
Scenario in datastage
input is cola 1 2 3 this should be populated at the output as cola 1 2 2 3 3 3