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,

---

project Steps,hits, Project level HArd things,Solved methods?

0 Answers   Hexaware,

---

How many types of stage?

0 Answers  

---

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

---

What is ibm datastage?

0 Answers  

---

---

Name the third party tools that can be used in datastage?

0 Answers  

---

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,

---

Can you explain tagbatch restructure operator?

0 Answers  

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

What can we do with datastage director?

0 Answers  

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

0 Answers  

---