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
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How many Key we can define in remove duplicate stage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How to reverse the string using unix?
Differentiate between datastage and informatica?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are orabulk and bcp stages?
Which algorithm you used for your hashfile?
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 aggtorec restructure operator?
Can you explain repository tables in datastage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between in process and inter process?
What is the precedence of stage variables,derivations, and constraints?
What are the main features of datastage?