i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---

Can you explain players in datastage?

0 Answers  

---

What are the types of hashed files in data stage

0 Answers  

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

What are the functionalities of link collector?

0 Answers  

---

---

WHAT are unix quentios in datastage

2 Answers   TCS,

---

Differentiate between datastage and informatica?

0 Answers  

---

How you can fix the truncated data error in datastage?

0 Answers  

---

what is data mapping

2 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

---

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,

---

how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

---