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 do you find the number of rows in a sequential file?

1 Answers  

---

root tree will find which is server job and which is parallel job?

0 Answers   IBM,

---

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

0 Answers  

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 Answers  

---

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

5 Answers   Cap Gemini,

---

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

---

Define repository tables in datastage?

0 Answers  

---

Explain usage analysis in datastage?

0 Answers  

---

What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

How to RD using transformer?

0 Answers   CTS,

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---