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
Difference between in process and inter process?
On which interface you will be working as a developer?
What are the types of hashed files in data stage
Define project in datastage?
What are the differences between datastage and informatica?
What is the difference between passive stage and active stage?
What is the importance of the exception activity in datastage?
Why do we use exception activity in Datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is a ds designer?
What are datastage sequences?
Define Merge?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
how to delete one row in target dataset