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 |
How you Remove the Dataset in Unix?
Wat is isolation level and when do u use them?
how can we create tables in datastage?
what is the definitions for Datawarehose and Datamart?
whom do you report?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
What is size of a transaction and an array means in a datastage?
What is the flow of loading data into fact & dimensional tables?
what is hash file
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
how to identifie,is it innerjoin,leftouter join in lookup?