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 / srinu
seqfile->sort->transformer->removeduplicate->targer
inser file load
col1
1
1
2
in the sort
key->sort
allowduplicate->true
keychangecolumn->true
in the transformer
create the stage variable
if keychnage=1 then col1 else stagevariablename:col1
drag col1 in transformer
in the derivation area only put stagevariable
remove duplicate:
key:col1
you select last records
we will get answer
col1
11
2
Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Triggers,VIEW,Procedures
What is datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Define oconv () and iconv () functions in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
Differentiate between data file and descriptor file?
How to find value from a column in a dataset?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is quality stage?
What is the command line function to import and export the ds jobs?
What is a merge in datastage?
What is the difference between Datastage 7.5 and 7.0?
What could be a data source system?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?