i have one table with one column in this column i have three
rows like 1,1,2 then that rows populate to target as first
tow rows as one row and remaing row as one row how it posible?
COLUMN_NAME
SHIVA
RAMU
MADHU
THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND
MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
Answer Posted / raj
Use a pivot stage
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are routines in datastage?
Can we use target hash file as a lookup ?
What are the job parameters?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Explain entity, attribute and relationship in datastage?
How to RD using transformer?
Differentiate between datastage and datastage tx?
How many Key we can define in remove duplicate stage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Which commands are used to import and export the datastage jobs?
How we can covert server job to a parallel job?
Can you explain kafka connector?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is the difference between datastage and datastage tx?
How to implement complex jobs in data stage?