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
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 |
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 |
What is the use of datastage designer?
why do we need a datawarehouse when we have databases to store data?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Define ds designer?
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
What are the different database update actions available?
What is the difference between validated and compiled in the datastage?
What is difference between 8.1 , 8.5 and 9.1 ?
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?
plz tell me some dimentional and fact table names in banking project?
What is the differentiate between data file and descriptor file?
What is the default padding character?