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 to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

---

What is the use of datastage director?

0 Answers  

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

0 Answers   Reliance,

---

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

---

what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

1 Answers   TCS,

---

Does datastage support slowly changing dimensions ?

0 Answers  

---

Define ds designer?

0 Answers  

---

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,

---

what is the use of surogate key in datastage

3 Answers  

---

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  

---

Differentiate between datastage and informatica?

0 Answers  

---

what is data mapping

2 Answers  

---