Define Merge?

0 Answers  

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  

---

How can you join flat file, oracle as a sources?

4 Answers   IBM,

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

0 Answers   Virtusa,

---

If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,

---

how can we do null handling in sequential files

2 Answers   Reliance,

---

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

---

Whats difference betweeen operational data stage (ods) and data warehouse?

0 Answers  

---

How to clean the datastage repository?

0 Answers  

---

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

---

how many types of remove the duplicate records?

3 Answers   Caterpillar,

---