if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

1)Source file contains one record, I want 100 records in target file.

3 Answers  

---

What are the types of containers in datastage?

0 Answers  

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

---

What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

What are the areas of application?

0 Answers  

---

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

---

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

---

What are the features of datastage flow designer?

0 Answers  

---

what are the errors,warnings in datastage

0 Answers   Syntel, Wipro,

---