Tuesday 22 September 2015

Difference between DataStage 7.5X2 and DataStage 8.0.1 Versions

Difference between DataStage 7.5X2 and DataStage 8.0.1 Versions

1) In DataStage 7.5X2, there are 4 client components. They are
a) DataStage Design
b) DataStage Director
c DataStage Manager
d) DataStage Admin

2) Datastage 8.0.1 Version,  5 components. They are
a) DataStage Design
b) DataStage Director
c) DataStage Admin
d) Web Console
e) Information Analyzer

Here DataStage Manager migrated into DataStage Design Category.



2) Datastage 7.X.2 Version is OS Dependent. That is OS users are Datastage Users.

and in 8.0.1
2)This is OS Independent . That is User can be created at DataStage, but one time dependent.

3) DataStage 7.X.2 version is File based Repository ( Folder).
3) DataStage 8.0.1 Version is DataStage Repository.

4) No Web based Administration here.
4) Web Based Administration.

5) There are 2 Architecture Components here. They are
a) Server
b) Client
5) There are 5 Architecture Components. They are
a) Common user Interface.
b) Common Repository.
c) Common Engine.
d) Common Connectivity.
e) Common Shared Services.


6) P-3 and P-4 can be performed here.
P-3 is Data Transformation.
P-4 is Metadata Management

6) P-1,P-2, P-3, P-4 can be performed here.
P-1 is Data Profiling
P-2 is Data Quality
P-3 is Data Transformation
P-4 is Metadata Management

7) Server is IIS

 Sever is WebSphere

8) No Web based Admin

Web based Admin.


Datastage 8.5 Enhacements


It was  more faster than  before versions.
All the  tasks become faster than previous version 8.1 .

Tasks are like save, renaming, compiling etc.

The run time of the jobs has been improved.

In DataStage transformer Stage is one of the important stage.


Transformer looping has been included in the transformer stage by I.B.M

There are two types of looping  available here.

Where we can output multiple O/P( Output )  links for single I/P( Input Link) Link.

For Example:

Input:

Name     Address-1       Address-2       Address-3

Manikanta    Palakol    Westgodavari   AndhraPradesh




Output will be

Name     Address

Manikanta    Palakol
Manikanta    WestGodavari
Manikanta    AndhraPradesh


This achieved  with the new system  variable @ ITERATION


System Variables:

@ ITERATION : used in the looping mechanism

LastRow(): Indicated the last row in the job

LastRowInGroup(): will return the last row in the group based  on the key.

WHAT ARE THE CLIENT COMPONENTS IN DATASTAGE 7.5X2 VERSION

In Datastage 7.5X2 Version, they are 4 client Components. They are

1) DataStage Designer
2) DataStage Director
3) DataStage Manager
4) DataStage Admin

In DataStage Designer, We
Create the Jobs
Compile the Jobs
Run the Jobs

In Director, We can
View the Jobs
View the Logs
Batch Jobs
Unlock Jobs
Scheduling Jobs
Monitor the JOBS
Message Handling


In Manager , We can
Import & Export the Jobs
Node Configuration

And by using Admin , We can
Create the Projects
Organize the Projects
Delete the Projects