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

Answer / balaji

these are mostly used in real time scenario:
database stages are:
1.oracle enterprise
2.tera data
3.db2
4.odbc
file stage are:
1.sequencial file stage
2.dataset
3.file set
4.hash file stage
processing stage are:
1.transformation
2.sort
3.modify
4.copy
5.funnel
6.lookup
7.surrogate key
8.join
9.aggregater
10 funnel stage
11.merge stage.

debugging stage are:
1.head stage
2.tail stage
3.peek stage

Answer / poorna

these are mostly used in real time scenario:
database stages are:
1.oracle enterprise
2.tera data
3.db2
4.odbc
file stage are:
1.sequencial file stage
2.dataset
3.file set
4.hash file stage
processing stage are:
1.transformation
2.sort
3.modify
4.copy
5.funnel
6.lookup
7.surrogate key
8.join
9.aggregater
10 funnel stage
11.merge stage
12.Change Capture
13.Filter

debugging stage are:
1.head stage
2.tail stage
3.peek stage

Answer / kishore reddy

database stages are:
1.oracle enterprise
2.tera data
3.db2
4.odbc
file stage are:
1.sequencial file stage
2.dataset
3.file set
4.hash file stage
processing stage are:
1.transformation
2.sort
3.modify
4.copy
5.funnel
6.lookup
7.surrogate key
8.join
9.aggregater
10 funnel stage
11.merge stage.

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

---

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

---

DataStage Scenario based Interview Questions

1 Answers  

---

what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,

---

how many dimentions and fact tables used in your project and what are names of it?

3 Answers   Tech Mahindra,

---

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

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

0 Answers  

---

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

---

How do you import and export the datastage jobs?

0 Answers  

---

When we will go for Data elements?

3 Answers   TCS,

---

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,

---

hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer 

1 Answers   HCL,

---