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
- 2 Answers
- 8264 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
explain about citrix scheduling tool in datastage
What is merge stage?
Nls stands for what in datastage?
whom do you report?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What could be a data source system?
What are the partitioning techniques available in link partitioner?
how to implement scd2 in datastage 7.5 with lookup stage
What is the use of datastage director?
Define ds designer?
Lookup constraints
What are the different kinds of views available in a datastage director?
Name the third party tools that can be used in datastage?
What are some prerequisites for datastage?
Explain datastage architecture?
