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;

Why do we use exception activity in Datastage?

1314

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3755

---

how many rows sorted in sort stage by default in server jobs

3997

---

What is the difference between server job and parallel jobs?

1153

---

How to implement complex jobs in data stage?

1112

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1277

---

What are the differences between datastage and informatica?

1177

---

Demonstrate experience in maintaining quality process standards?

2550

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2046

---

Name the command line functions to import and export the DS jobs?

1155

---

What are the types of containers?

1235

---

What are stage variables and constants?

1147

---

Define Job control?

1145

---

What is usage analysis in datastage?

1306

---

Define repository tables in datastage?

1157

---