Answer Posted / 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

What is the sortmerge collector?

1173

---

How to clean the datastage repository?

1176

---

Describe stream connector?

1356

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

852

---

What is the precedence of stage variables,derivations, and constraints?

1123

---

Explain Quality stage?

1205

---

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

2547

---

What are the benefits of datastage?

1301

---

Explain the situation where you have applied SCD in your project?

2084

---

What is job control?

1192

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2773

---

Define meta stage?

1255

---

what is the use of materialized view?

1631

---

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?

1094

---

which r the connectors used in san?

2226

---