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.

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1371

---

What steps should be taken to improve Datastage jobs?

1003

---

Name the different types of Lookups in Datastage?

1214

---

Describe stream connector?

1245

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1297

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3265

---

How do y read Sequential file from job control?

15801

---

Differentiate between data file and descriptor file?

988

---

How a source file is populated?

1020

---

Can you explain tagbatch restructure operator?

1118

---

Distinguish between informatica & datastage. Which one would you choose and why?

954

---

What are the different common services in datastage?

1216

---

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

2676

---

Explain connectivity between datastage with datasources?

942

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

725

---