What is the Difference Between DataStage 7.5 version and 8.1
Version?
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 |
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
What is meta stage?
Whats difference betweeen operational data stage (ods) and data warehouse?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what is the use of surogate key in datastage
on how many columns we can perform aggregation in the Aggregator stage?
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
i have flat file and using unix how can i generate sequence number into targer?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
What is usage analysis in datastage?
How can we improve the performance in datastage?
What could be a data source system?