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;

How will you move hashed file from one location to another location?

2095

---

Can we use target hash file as a lookup ?

3264

---

What all are the different way to run a job?

1030

---

Why we use surrogate key?

1159

---

What are the different kinds of views available in a datastage director?

973

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2133

---

How can you write parallel routines in datastage PX?

976

---

Lookup constraints

1201

---

How do you remove duplicate values in datastage?

1097

---

Define orabulk and bcp stages?

1069

---

How do you start developing a datastage project?

1059

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1333

---

What is the precedence of stage variables,derivations, and constraints?

1030

---

Describe the architecture of datastage?

952

---

What is a folder? Difference types of stages?

1104

---