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 :)

How do you run datastage job from the command line?

1081

---

What are some prerequisites for datastage?

1095

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2612

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2459

---

What are transforms and what is the differenece between routines and transforms?

1062

---

Describe the architecture of datastage?

1002

---

What is orabulk stage?

1045

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1499

---

What is difference between symmetric multiprocessing and massive parallel processing?

1136

---

Is possible to create skid in dim,fact tables?

2634

---

Differentiate between odbc and drs stage?

1048

---

how to implement scd2 in datastage 7.5 with lookup stage

5601

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2291

---

What is merge stage?

1302

---

how to sort two columns in single job in datastage.

2897

---