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
- 8573 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
Why do we use link partitioner and link collector in datastage?
What is the difference between operational data stage (ods) and data warehouse?
What are data elements?
Which warehouse using in your datawarehouse
Explain ibm infosphere information server and highlight its main features?
Explain Quality stage?
How many areas for files does datastage have?
What is apt_config in datastage?
What is the difference between validated and compiled in the datastage?
What steps should be taken to improve Datastage jobs?
What are the difference types of stages?
What are the functionalities of link partitioner?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are some prerequisites for datastage?
What is the different type of jobs in datastage?
