Answer Posted / np

Use Pivot stage

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

1032

---

Difference between sequential file and data set?

1136

---

What is a quality stage in datastage tool?

1025

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3701

---

State the difference between an operational datastage and a data warehouse?

1057

---

How to manage date conversion in Datastage?

1071

---

what is the use of surogate key in datastage

2250

---

Why fact table is in normal form?

1150

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

995

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2156

---

What is the different type of jobs in datastage?

902

---

How to RD using transformer?

1367

---

Can you filter data in hashed file?

3725

---

What is usage analysis in datastage?

1263

---

What are the partitioning techniques available in link partitioner?

2228

---