Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Difference Between DataStage 7.5 version and 8.1
Version?
- 10 Answers
- 68784 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santhosh
hi this is madhu.
main differences b/w datastage 7..52 to 8.0.1
1. in ds 7.5.2 we have manager as client. in 8.0.1 we dont
have any manager client. the manager client is embeded in
designer client.
2.in 7.5.2 quality stage has seperate designer .in 8.0.1
quality stage is integrated in designer.
3.in 7.5.2 code and metadata is stored in file based
system.in 8.0.1 code is a file based system where as
metadata is stored in database.
4.in 7.5.2 we required operating system authentications. in
8.0.1 we requiree operating system authentications and
datastage authentications.
5.in 7.5.2 we dont have range lookup. in8.0.1 we have
range lookup.
6. in 7..5.2 a single join stage can't support multiple
references. in 8.0.1 a single join stage can support
multiple references.
7.in 7.5.2 , when a developer opens a particular job, and
another developer wants to open the same job , that job
can't be opend. in 8.0. it can be possible when a developer
opens a particular job and another cdeveloper wants to open
the same job then it can be opend as read only job.
8. in 8.0.1 a compare utility is avilable to compare 2
jobs , one in development another is in production. in
7.5.2 it is not possible
9. in 8.0.1 quick find and advance find features are
avilable , in 7.5.2 not avilable
10.in 7.5.2 first time one job is run and surogate key s
generated from initial to n value. next time the same job
is compile and run again surrogate key is generated from
initial to n. automatic increment of surrogate key is not
in 7.5.2. but in 8.0.1 surrogate key is incremented
automatically.a state file is used to store the maximum
value of surrogate key.
| Is This Answer Correct ? | 76 Yes | 5 No |
Answer / vinay kumar
datastage 8.1 version have quality control,information
analyzer.datastage designer,datastage director& datastage
manager are integrated in 8.1 and also some of new stage
are added. where as 7.5 have separate degin,manager,director
| Is This Answer Correct ? | 50 Yes | 8 No |
Answer / swetha
In 7.5we have designer,director,manager,admin but in 8.0.1
manager includedd in designer.added some new stages range
lookup and scd stage.
connection objects are new objects that hold connection
information user name and password,database name to a
particular source or target which allows saving and reusing
connection information.
surrogate key generator stage whre will generate the
surrogate keysacrosss job execution runs.A new surrogate
key generator stage support following sources to generate
the sequence numbers(I)DB Sequence(II)File.
new connectors are invented the new connetors are easier to
use and extent functionality from existing connectors.
| Is This Answer Correct ? | 20 Yes | 4 No |
Answer / sharan
Datastage 8.1 : 1.It is integrated with default database DB2
and Websphere application server.
2. It has SCD stage.
Datastage 7.5 : 1.It has default universe database.
2. It has no SCD stage.
| Is This Answer Correct ? | 22 Yes | 11 No |
Answer / raghunath
Data stage 7.5:
1. it is standard tool.
2. Repository is Universal.
like DBMS.
3. It have 4 client components.
4. No WAS.
5. ETL TOOL.
Information Server 8.1:
1. It is integration tool & Quality analysis, profile stage.
2. It is ETL & Quality tool
3. Repository is RDBMS
like db2,oracle.
4. it is having WAS.
5. it is having three client components.
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / saidarao
1. in 7.5 it having data transformation,metadata mgmt,where
is in 8.0.1 ,data perform,data quality,data
transformation,metadata mgmt involve.
2.in 7.5 involve two tier architecture where as 8.0.1,n-tier
architecture.
3.operating system dependent,where as in 8.0.1 ,operating
system independent.
4.no web base administrator,where as in 8.0.1 having web
base administrator.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / chandu
In 7.5 there is no parameterset option available where as in 8.0.1 version onwards there was parameterset .
In the 7.5 there was no sharedcontainer where as in 8.0.1 version there was a shared container available.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / svr
data stage 7.5.2 data stage 8.0.1
1-single execute system multiple execute system
2-here change aplly & capture Here SCD TYPES R USED
stages r used
3- file based repostry it is data based repository
| Is This Answer Correct ? | 2 Yes | 5 No |
explain unit testing,systemtesting,integrated testing
Lookup constraints
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
How to read the length of word in unix?
What is the difference between odbc and drs stage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
what is the best stage in datastage parller jobs to use full out join and why
Have you used Unstructured data?
How to perform incremental load in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
how to handle null values using transformer stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Teradata 
