how to achieve this output ?
Two Input columns(ID & Name) -
ID | Name
1 | Jack
1 | Kara
In output there should be only 1 column which will be populated as -
1,Jack
1,Kara
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between datasatge and datastage TX?
project Steps,hits, Project level HArd things,Solved methods?
how to convert rows into columns
how to sort two columns in single job in datastage.
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
How many areas for files does datastage have?
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Differentiate between Join, Merge and Lookup stage?
What are the prerequisites for join stage
State the difference between an operational datastage and a data warehouse?