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 This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,

---

How to reverse the string using unix?

0 Answers   CTS,

---

How to read the length of word in unix?

0 Answers   CTS,

---

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  

---

---

DataStage Scenario based Interview Questions

1 Answers  

---

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

---

On which Dimension Table you implemented SCD Type in your Project

0 Answers  

---

How do u convert the columns to rows in datastage?

0 Answers  

---

What is the use of datastage director?

0 Answers  

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

0 Answers  

---

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,

---