Answer Posted / archana

7.5
--------
->no surrogate key generator
->Range lookup is not here
->quality stage not introduced
->Added passive stages
->scd is not here
->open quick find option not here
->users are created OS level
->file based repository
->web sphere datastage
->oracle enterprise stage
->one job can open by one person only
->we can handle if any syntax errors at source level with the help of more option in event detail window in oracle enterprise stage option

8.0
----
->surrogate key generator
->Range lookup is here
->quality stage introduced
->Added oracle enterprise,netezza enterprise,classis federation stages
->scd is present here
->open quick find option here
->users are created OS level and datastage level
->data based repository
->Infosphere datastage
->oracle connector
->one job can open by multiple,with read only mode.
->we cannot handle in oracle connector.

Differentiate between data file and descriptor file?

1068

---

AGGREGATOR default datatype

1470

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2218

---

How to convert RGB Value to Hexadecimal values in datastage?

4007

---

Define Merge?

1325

---

What are the difference types of stages?

1223

---

what is ds administrator used for?

1183

---

Where the datastage stored his repository?

1096

---

What are the functionalities of link partitioner and link collector?

1015

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2455

---

In Datastage, how you can fix the truncated data error?

1169

---

What are sequencers?

1124

---

What is meta stage?

1190

---

What are the some differences between 7.x and 8.x version of datastage?

1267

---

Describe link sort?

1019

---