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
Have you have ever worked in unix environment and why it is useful in datastage?
Is possible to create skid in dim,fact tables?
Does datastage support slowly changing dimensions ?
What is the flow of loading data into fact & dimensional tables?
What are stage variables?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Explain the importance of surrogate key in data warehousing?
What is the importance of the exception activity in datastage?
What are the different layers in the information server architecture?
what is the use of surogate key in datastage
Describe routines in datastage? Enlist various types of routines.
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How do you reject records in a transformer?
Define Data Stage?
How to perform incremental load in datastage?