Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 10061 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
What is orabulk stage?
AGGREGATOR default datatype
What is active and passive stage?
How do u convert the columns to rows in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How many Key we can define in remove duplicate stage?
What are the types of containers?
Notification Activity
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Can you explain kafka connector?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the components of datastage?
Can we use target hash file as a lookup ?
