1. Take a copy of the file in two links where id only in one link and value

Hi guys,

7. how to get this output
i/p
col1,col2
101,a
102,b
103,c
104,d

o/p
col1,col2
101,d
102,c
103,b
104,a

Thanks

Question Posted / anil

2 Answers
9629 Views
Cap Gemini, IBM, I also Faced
E-Mail Answers

Answer Posted / anil

1. Take a copy of the file in two links where id only in one link and value in another link.

2. For id link add a column generator for giving row number(Temp). Run this in sequential mode. Parition by Sort Merge (ascending)

3. For value link add a column generator for giving row number(Temp). Run this in sequential mode. Parition by Sort Merge (descending).

4. Now add look up between two columns with Temp as lookup.

5. You will get the output as desired.

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2814

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2264

Define data aggregation?

1103

Name the different types of Lookups in Datastage?

1263

Describe the main features of datastage?

1077

what is the use of skid in reporting?

2381

What is the use of datastage designer?

1158

Why fact table is in normal form?

1258

How do you schedule or monitoring the job?

1210

What is a ds designer?

1070

What are the different options associated with dsjob command?

1442

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

3759

How a server job can be converted to a parallel job?

1096

What is the purpose of pivot stage and types of containers in datastage

1042

How we can covert server job to a parallel job?

1151