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 are the different plug-ins stages used in your projects?

1027

---

What is the roundrobin collector?

1038

---

What are the different options associated with dsjob command?

1370

---

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

1148

---

How one source columns or rows to be loaded in to two different tables?

1071

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1171

---

Differentiate between operational datastage (ods) and data warehouse?

1116

---

Notification Activity

1348

---

What is oci?

1259

---

What is the difference between informatica and datastage?

1146

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3968

---

How to read the length of word in unix?

1311

---

Difference between sequential file and data set?

1134

---

EXPLAIN SCD

1339

---

What are stage variables, derivations and constants?

1165

---