Answer Posted / amit

read the file from sequential file stage, use a transformer in between, write the same data to the same file using sequential file stage as target by setting option to - load file in append mode.

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2813

---

How many Key we can define in remove duplicate stage?

1386

---

Can we use target hash file as a lookup ?

3327

---

Can you explain engine tier in information server?

1135

---

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

2040

---

How you Implemented SCD Type 1 & Type 2 in your project?

4129

---

What are the partitioning techniques available in link partitioner?

2279

---

How a server job can be converted to a parallel job?

1094

---

What is quality stage?

987

---

Define meta stage?

1202

---

What are stage variables?

1202

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2800

---

What are the various kinds of containers available in datastage?

1048

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

---

What are the processing stages?

1100

---