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 some prerequisites for datastage?

1100

---

How to clean the datastage repository?

1127

---

What are the types of hashed files in data stage

1108

---

How to perform incremental load in datastage?

1203

---

Explain connectivity between datastage with datasources?

977

---

On which Dimension Table you implemented SCD Type in your Project

2047

---

What are the different kinds of views available in a datastage director?

1030

---

What are the types of views in datastage director?

1775

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2903

---

What is the difference between datastage and datastage tx?

1067

---

Can we use target hash file as a lookup ?

3327

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2865

---

What is the process of killing a job in datastage?

1020

---

What is difference between server jobs & parallel jobs?

1038

---