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 / prasad
Question is not clear.
U want 1,1 records goes to one target and duplicate records goes to another target, is it right? can u plz conform this and just let me know?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to sort two columns in single job in datastage.
What is use Array size in datastage
Does datastage support slowly changing dimensions ?
What are the functionalities of link collector?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the enhancements made in datastage 7.5 compare with 7.0?
what is the difference between == and eq in UNIX shell scripting?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is difference between join, merge and lookup stage?
What is ibm datastage flow designer?
Have you have ever worked in unix environment and why it is useful in datastage?
To see hidden files in LINIX?
Terminate Activity
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?