What is the Difference Between DataStage 7.5 version and 8.1
Version?
Answer Posted / 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 |
Post New Answer View All Answers
How the ipc stage work?
Name the different sorting methods in datastage.
Name the different types of Lookups in Datastage?
Why do you need stage variables?
root tree will find which is server job and which is parallel job?
What is ibm datastage flow designer?
How many types of sorting methods are available in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
whom do you report?
What is the process of killing a job in datastage?
Differentiate between hash file and sequential file?
Can you explain players in datastage?