Answer Posted / bietl

if you are working on server jobs then this are the stages
we can use commonly..

1.seq.file stage
2.transformer stage
3.hashfile stage
4.sort stage and agg.stage

if you are working on parallel jobs then this are the
stages we can use commonly..


1.Datset stage
2.transformer stage
3.lookupstage
4.Join stage
5.funnel and merge stage

mostly it's depends on the transformation logic and complex
of the logic..

I hope this will help..

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2957

---

Why do you need stage variables?

1170

---

What is difference between symmetric multiprocessing and massive parallel processing?

1124

---

What is size of a transaction and an array means in a datastage?

1287

---

What is the importance of the exception activity in datastage?

1055

---

What is the purpose of pivot stage?

1155

---

Lookup constraints

1236

---

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

995

---

What is the difference between an operational datastage and a data warehouse?

1137

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1102

---

What is a merge in datastage?

1249

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2076

---

Define repository tables in datastage?

1142

---

How do you remove duplicate values in datastage?

1137

---

Describe the main features of datastage?

1066

---