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

Answers were Sorted based on User's Feedback



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

Answer / ankit gosain

Hi all,

For this scenario, construct a job like:


SeqFile------>Transformer------>Transformer----->SeqFile


Firstly, Change the execution mode of both the transformers
from default(parallel) to sequential.
Now, create a stage variable of varchar type in 1st
Transformer (say temp) & assign a default value to it
(say 'Ankit').
Now write in its derivation:
if temp='Ankit' then col2 else temp:',':col2

Now give the o/p derivation for the two columns as:
col1---col1
temp---col2

Now go to the 2nd Transformer & go to input tab and mention
the sorting on col1 as descending, create 3 stage variables
in it:
count1 of integer type with 0 as default value,
temp1 of varchar type with 'Ankit' as default value,
temp2 of varchar type.
then write in their derivation:

count1+1----------------------------------count1
if temp1='Ankit' then col2 else temp2-----temp1
temp1-------------------------------------temp2

Now write in O/p derivation of the columns:

col1-----------------------col1
field(temp2,',',count1)----col2

Now, do the sorting (ascending) on col1 in the o/p seqFile,
and drag & drop both the columns to the o/p link derivation
and you wil get the desired result.

If you have further queries, mail me on
ankitgosain@gmail.com

Cheers,
Ankit :)

Is This Answer Correct ?    7 Yes 1 No

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

Answer / 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

More Data Stage Interview Questions

What is the use of datastage designer?

0 Answers  


why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,


how to run a sequential file stage in parallel if the stage is used on the TARGET side

0 Answers   Virtusa,


Define ds designer?

0 Answers  


create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,






What are the different database update actions available?

1 Answers   HP,


What is the difference between validated and compiled in the datastage?

0 Answers  


What is difference between 8.1 , 8.5 and 9.1 ?

1 Answers   IBM,


how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,


plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,


What is the differentiate between data file and descriptor file?

0 Answers  


What is the default padding character?

3 Answers   IBM,


Categories