Warehouse DataStage Question: Download Warehouse DataStage PDF
Explain What is merge and how it can be done plz explain with simple example taking 2 tables?
Answer:
Merge is used to join two tables.It takes the Key columns sort them in Ascending or descending order.Let us consider two table i.e Emp,Dept.If we want to join these two tables we are having DeptNo as a common Key so we can give that column name as key and sort Deptno in ascending order and can join those two tables
| Previous Question | Next Question |
| Explain How to run the job in command prompt in unix? | Explain What is the difference between Symetrically parallel processing,Massively parallel processing? |