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.

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

---

Main Function of the Staging area in DWH ?

2 Answers  

---

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

---

How to Convert the columns into rows?

2 Answers  

---

what is normalization and denormalization

2 Answers   CTS,

---

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

---

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  

---

source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,

---

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 Answers  

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

0 Answers  

---