seqfile->sort->transformer->removeduplicate->targer inser file

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

Question Posted / srinu

3 Answers
10186 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

Please Help Members By Posting Answers For Below Questions

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1554

What are the types of views in datastage director?

1822

How to perform incremental load in datastage?

1260

Explain entity, attribute and relationship in datastage?

1151

Distinguish between informatica & datastage. Which one would you choose and why?

1038

What are the various kinds of the hash file?

1192

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3290

Define Job control?

1220

Name the different types of Lookups in Datastage?

1311

What is usage analysis in datastage?

1357

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3805

Define meta stage?

1254

Define Merge?

1369

How to reverse the string using unix?

3583

What is a merge in datastage?

1340