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

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2865

---

What is the use of datastage designer?

1154

---

Define ds designer?

1283

---

What is datastage?

1084

---

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

1315

---

What all are the different way to run a job?

1095

---

What is the difference between orabulk and bcp stages?

1027

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2903

---

What are the various kinds of the hash file?

1151

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2970

---

Define Job control?

1148

---

Explain the importance of surrogate key in data warehousing?

1191

---

What is the difference between informatica and datastage?

1229

---

What are the types of containers and how to create them?

980

---