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..

State the difference between an operational datastage and a data warehouse?

1055

---

How do you start developing a datastage project?

1056

---

To see hidden files in LINIX?

1449

---

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 ?

1962

---

What are transforms and what is the differenece between routines and transforms?

998

---

What is ibm datastage?

914

---

What is the difference between odbc and drs stage?

1042

---

What is the project in datastage?

1045

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1439

---

Where the datastage stored his repository?

1018

---

What are system variables and sequencers in datastage

1067

---

Differentiate between operational datastage (ods) and data warehouse?

1115

---

How can one find bugs in job sequence?

1316

---

Explain connectivity between datastage with datasources?

938

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1365

---