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 |
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
0 Answers Alpharithm Technologies,
What are constraints and derivations?
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
How many Key we can define in remove duplicate stage?
Main Function of the Staging area in DWH ?
What are the different type of jobs in datastage?
How complex jobs are implemented in datstage to improve performance?
What is the use of surrogate key stage?
difference between server shared container and parallel shared container
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
What is the precedence of stage variables,derivations, and constraints?