Datastage 8.1 Notes || Ecode Stage || Decode Stage || Defference between Filter, Switch, External Filter

Datastage 8.1 Notes || Ecode Stage || Decode Stage || Defference between Filter, Switch, External Filter

&

Extraction process of XLS data with ODBC Enterprise Stage:

Differences Between Filter, Switch, External Filter

Filter stage:

1.Condition can put on Multiple Columns

2.It  Have 1-Input,N-Output, 1-Reject Link

Switch stage:

1.Condition can put on Single Column

2.It  Have 1-Input,128-Output, 1- default Reject Link

External Filter stage:

1.Here we can use All unix Filter commands

2.It  Have 1-Input,1-Output, No-Reject Link

ENCODE STAGE:

1.It is processing stage that encodes the records into single format with the support of

command line”.

2.It supports – “1-input and 1-output”.

Properties:

Ø  Stage

§  Options   Command Line=Compress/gZip

Ø  Input

Ø  Output

§  Load the meta data of  source files

DECODE STAGE:

1.It is processing stage that decodes the encoded data”.

2.It supports – “1-intput and 1-output”.

Properties:

Ø  Stage

§  Options: command line = (uncompress/gunzip)

Ø  Output

• Load the ‘Meta’ data of the source file.

Differences Between Oracle Enterprise Stage, ODBC Enterprise Stage:

Oracle enterprise stage and ODBC Enterprise stage’s are database extraction or Loading perpose using in Datastage.

1.Oracle Enterprise Stage

1.Version Dependent

2.Good Performance

3.Specific to Oracle

4.Uses Plug Ins

5.No rejects at source

2.ODBC Enterprise Stage:

1.Version In Dependent

2.Poor Performance

3.Use for Multiple DB

4.Uses OS Drivers

5.Rejects at source and Target

Extraction process of XLS data with ODBC EnterpriseStage:

First step is to create MS Excel that is called “work book”. It’s having ‘n’ number of

sheets in that.

 For example CUST work book is created

1.Read  Excel work book with  ODBC Enterprise Stage:

Read Method=Table

Table=”emp1$” \\when we reading from excel name must be in double codes end with $ Symbol

Connections

DSN=EXE

Password=OS system password

User=OS system  user name

Columns

• Load
• Import ODBC Table Defination
• DSN  here select work Book
• User ID and Password

Operating System

Add in ODBC

§  MS EXCEL Drivers

§  Name=EXE (DSN)

Datastage 8.1 Full Notes Download :

Click Here to More Datastage 8.1 Notes& Interview Details :