Answer Posted / subhash

OUTPUT:
1, a, d
2, b, NULL
3, NULL, c

SQL Query:
SELECT * FROM TAB1 FULL OUTER JOIN TAB2 ON
TAB1.key_column=TAB2.key_column;

or

SELECT * FROM TAB1,TAB2 WHERE
TAB1.key_column=TAB2.key_column(+)
UNION
SELECT * FROM TAB1,TAB2 WHERE
TAB1.key_column(+)=TAB2.key_column;

Differentiate between datastage and informatica?

1151

---

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

740

---

how to delete one row in target dataset

3075

---

How many types of views are there in a datastage director?

1245

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2141

---

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

1311

---

What steps should be taken to improve Datastage jobs?

1015

---

What is use Array size in datastage

1730

---

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

945

---

How do you register plug-ins?

934

---

What is the difference between datastage and datastage tx?

1019

---

What are the functionalities of link partitioner?

983

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2207

---

How we can covert server job to a parallel job?

1076

---

What could be a data source system?

958

---