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 is use of SDR function?

5223

---

Does datastage support slowly changing dimensions ?

1156

---

What is the difference between orabulk and bcp stages?

1072

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2074

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1112

---

Why fact table is in normal form?

1307

---

Notification Activity

1457

---

Enlist various types of routines in datastage.

1328

---

What is the project in datastage?

1165

---

What are stage variables?

1252

---

Have you used Unstructured data?

1368

---

How can one find bugs in job sequence?

1493

---

What all the types of jobs you developed?

1247

---

On which Dimension Table you implemented SCD Type in your Project

2112

---

Describe the main features of datastage?

1123

---