Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9445 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
options available in sequence job to run,validate?
What are routines in datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
How to perform incremental load in datastage?
What is datastage?
root tree will find which is server job and which is parallel job?
Why we use surrogate key?
What are stage variables?
Why do we use exception activity in Datastage?
How to clean the datastage repository?
What is difference between server jobs & parallel jobs?
Explain connectivity between datastage with datasources?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How many types of hash files are there?
Can you define merge?
