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.

Different ways a project can be moved to production ?...example ….export-import and Version control.

2449

---

What are the different options associated with dsjob command?

1441

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2261

---

What are the different types of lookups in datastage?

1054

---

Where the datastage stored his repository?

1089

---

What is meta stage?

1183

---

How to clean the datastage repository?

1127

---

What is a merge in datastage?

1271

---

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

1008

---

What is ibm datastage flow designer?

1149

---

What are the types of views in datastage director?

1775

---

How to implement complex jobs in data stage?

1112

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

---

Give an idea of system variables.

1036

---

What is the difference between datastage and datastage tx?

1066

---