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

How can you write parallel routines in datastage PX?

1065

---

Why fact table is in normal form?

1309

---

Have you used Unstructured data?

1370

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

823

---

how to write server Routine coding?

2181

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1922

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1581

---

how to sort two columns in single job in datastage.

2957

---

What is aggtorec restructure operator?

1525

---

What are the different options associated with dsjob command?

1483

---

Differentiate between Join, Merge and Lookup stage?

1141

---

Describe the main features of datastage?

1125

---

Can you explain players in datastage?

1247

---

What are routines in datastage? Enlist various types of routines.

1154

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1323

---