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

Differentiate between datastage and informatica?

1251

---

What is datastage?

1133

---

What is size of a transaction and an array means in a datastage?

1368

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2536

---

How to convert RGB Value to Hexadecimal values in datastage?

4060

---

What could be a data source system?

1098

---

What is ibm datastage?

1025

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2854

---

in oracle target stage when we use load option and when we use upsert option?

2324

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1131

---

Define Merge?

1374

---

What is the difference between passive stage and active stage?

1648

---

Is the value of staging variable stored temporarily or permanently?

1056

---

How we can covert server job to a parallel job?

1261

---

Explain Quality stage?

1211

---