Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 9946 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / raj
Use a pivot stage
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you remove duplicate values in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the sortmerge collector?
What is the roundrobin collector?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How do you reject records in a transformer?
What is the difference between hashfile and sequential file?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are the functionalities of link collector?
How and where you used hash file?
What is the difference between account and directory options ?
Why we use surrogate key?
Is possible to create skid in dim,fact tables?
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?
Explain ibm infosphere information server and highlight its main features?
