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,

---

when will you go for dataset and fileset?

2 Answers   Accenture,

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  

---

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

---

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

---

Explain connectivity between datastage with datasources?

0 Answers  

---

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,

---

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 Answers   TCS,

---

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

2 Answers   Wipro,

---

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

0 Answers  

---