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;

Notification Activity

1456

---

What are stage variables, derivations and constants?

1280

---

How to reverse the string using SQL?

1591

---

What are the functionalities of link collector?

1133

---

What is the difference between validated and compiled in the datastage?

1366

---

Can you highlight the main features of ibm infosphere information server?

1125

---

How do you run datastage job from the command line?

1127

---

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

1456

---

What is datastage engine?

1223

---

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.

2953

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2265

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1597

---

How we can covert server job to a parallel job?

1256

---

What is the importance of the exception activity in datastage?

1111

---

What is difference between symmetric multiprocessing and massive parallel processing?

1196

---