Answer / bharath

Instead of transformation use Combination in datastage,

Horizontal combining:
> join
> look-up
> merge
Vertical combining:
> remove duplicates
> Aggregation
Diagonal Combining:(not sure)
> vertical pivoting
> Horizontal Pivoting

Answer / npr

IS it DWH question ???????

What is the use of surrogate key stage?

2 Answers  

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers  

---

What are the functionalities of link collector?

0 Answers  

---

What are the partition techniques available in your last project?

1 Answers  

---

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

---

Which algorithm you used for your hashfile?

0 Answers  

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

---

What is audit table?

1 Answers  

---

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

---

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

---

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

1 Answers   IBM, TCS,

---

what is meta data? Explain? Where it is used?

9 Answers  

---