Answer Posted / manohar palla

I am going to use tranformer and funnel stages to implement the
pivot functionality.


name ph1 ph2---> tranformer--->tf1 name ph1
| funnel---->o/p
|____>tf2 name ph2

tf1 and tf2 are the TWO links from transfomer..

in tf1 we have the name and ph1 where in tf2 name and ph2.

In funnel stage i am going to club the two links and send it
to o/p.


Thanks :)

What are the steps required to kill the job in Datastage?

1165

---

Explain entity, attribute and relationship in datastage?

1059

---

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

1028

---

What is the purpose of pivot stage?

1111

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2457

---

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?

1005

---

what is ds administrator used for?

1126

---

What steps should be taken to improve Datastage jobs?

1016

---

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

1049

---

Difference between server jobs & parallel jobs?

1026

---

What are the areas of application?

1106

---

Define Job control?

1085

---

Why fact table is in normal form?

1161

---

root tree will find which is server job and which is parallel job?

1894

---

How many Key we can define in remove duplicate stage?

1331

---