Answer / 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;

Answer / subhash

OUTPUT:

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

Answer / karthi

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 U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

---

How to read multiple files using a single datastage job if files have the same metadata?

0 Answers  

---

How do you remove duplicate values in datastage?

0 Answers  

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  

---

job locking methods? How can we unlock the job?

3 Answers   IBM,

---

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

---

What are the job parameters?

0 Answers  

---

On which interface you will be working as a developer?

0 Answers  

---

What is PX?

2 Answers   IBM,

---

Define APT_CONFIG in Datastage?

0 Answers  

---

Can you explain kafka connector?

0 Answers  

---

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

---