Filter's & Data Set in Data Stage

Filter

Example

EnoEnameDno
100Moon12
200Moon soon13
300Mani14
400Mani kumar16
500Mani18
600Moon20
700Def22
800stu24

 

 

  • Grep “moon”

EnoEnameDno
100Moon12
200Moon Soon13

 

  • Grep - I “moon”

EnoEnameDno
100Moon12
200Monsoon13
600moon20

 

  • Grep - w “moon”

EnoEnameDno
100Moon12

 

  • Grep - v “moon”

EnoEnameDno
300Mani14
400Mani Kumar16
500Mani18
600Moon20
700Def22
800stu24

 

Data set :-  (.ds Extension)

limitations of Sequential file Stage:-

  1. Sequential file stage by default process the data

 

SRC      7     Staging Area

Extraction 

Screenshot_42

 

  • Here data gets Stored in a local Server (or) local Repository (or) Data base
  • Using Sequential file , data gets stored in local server . bet file format.

 

Sequential file stage has an Memory limit

Screenshot_43

Learn DataStage by Tekslate - Fastest growing sector in the industry.

Explore Online DataStage Training and course is aligned with industry needs & developed by industry veterans.

Tekslate will turn you into DataStage Expert.

Conversion takes place , when we use Sequential file stage for staging the data

 

  • A stage is an operator prebuilt in component
  • Sequential file is associated with import and export operators

Screenshot_44

 

 Data lands outside the Data stage

For indepth understanding of DataStage click on