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.

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 Answers   TCS,

---

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,

---

how to find no.of records in sequntial file itself?

4 Answers  

---

What are the various kinds of containers available in datastage?

0 Answers  

---

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

---

---

What is the differentiate between data file and descriptor file?

0 Answers  

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

3 Answers   TCS,

---

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

---

What could be a data source system?

0 Answers  

---

HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?

1 Answers   Infosys,

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---