Answer / venu

from 8.0 onwars in lookup rangelookup was interduced,in
transformer also having so many changes like servogate key
genarator in transformer it self,and datastage manager was
included designer itself

Answer / bharath

1.in 7.5 we have separate designer in for datastage and
quality stage. where as in 8.0.1 datastage and quality stage
both are having same designer.
2.in 7.5 we have manager client and designer client are
separate. in 8.0.1 we have manger client is embedded in
designer client itself.
3.in 7.5 we don't have range look up option, where as in
8.0.1 we have range lookup.

Answer / kak

In 8.0 onwards range lookup,caseless lookup are added.
newly scd stage is added.
IBM information server and control for IBM information
server added.
Parameter set this is very useful in 8.0 using this we can
save the parameters of one job and reuse in another job.

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

How we can convert rows to columns in datastage?

4 Answers   IBM,

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  

---

How can one find bugs in job sequence?

0 Answers  

---

What are iconv and oconv?

0 Answers  

---

how to delete one row in target dataset

0 Answers   Satyam,

---

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  

---

What is the project in datastage?

0 Answers  

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

---

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---