Answer Posted / radhika m

Add an extra column 'colA' and 'colB' to the files 'A' and 'B' respectively. Let the value for colsA be 'a' for all the rows in file 'A' and the value for colB be 'b' in file 'B'(using the column generator stage).Now join both the files using join stage using 'ID' column. Perform full outer join. Map the ID col, colA and colB to output. Next pass it through a transformer.

Transformer constraint:

1) file X - colA=a and colB<>b ----->[1,2,3,4,5]
2) file Y - colA=a and colB=b------->[6,7,8,9,10]
3) file Z - colA<>a and colB=b------>[11,12,13,14,15]

Drop cola and colB in the output.

How a server job can be converted to a parallel job?

1096

---

Which algorithm you used for your hashfile?

1186

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2388

---

What is the purpose of pivot stage?

1170

---

How you can fix the truncated data error in datastage?

1793

---

What is merge stage?

1318

---

Define meta stage?

1207

---

How the ipc stage work?

1134

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2179

---

How to Remove Duplicate using SQL?

1373

---

How to reverse the string using SQL?

1536

---

Describe routines in datastage? Enlist various types of routines.

1016

---

What is a quality stage in datastage tool?

1079

---

What are the various kinds of containers available in datastage?

1048

---

what is use of SDR function?

5175

---