Answer / Sarvesh Singh

DataStage supports various third-party tools such as Teradata Integrator, Informatica PowerCenter, IBM InfoSphere Data Services, and SAP Data Services for integrating data from multiple sources and transforming it as needed.

how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,

---

EXPLAIN SCD

1 Answers   CTS,

---

On which interface you will be working as a developer?

1 Answers  

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1 Answers  

---

What is usage analysis in datastage?

1 Answers  

---

Explain the scenarios where sequential file stage runs in parallel?

3 Answers   Accenture,

---

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

---

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

---

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  

---

In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.

2 Answers   IBM,

---

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,

---