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
Answers were Sorted based on User's Feedback
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 |
what is .dsx files
What are the various kinds of containers available in datastage?
Difference between data warehousing and olap?
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
What is the difference between account and directory options ?
What is data partitioning?
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
can we use sequential file as a lookup
1)Source file contains one record, I want 100 records in target file.
what is the Difference Between Datastage Server Edition and Parallel Edition?
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?