Filter's & Data Set in Data Stage

Ratings:
(4)
Views:0
Banner-Img
  • Share this blog:

Filter

Example

Eno Ename Dno
100 Moon 12
200 Moon soon 13
300 Mani 14
400 Mani kumar 16
500 Mani 18
600 Moon 20
700 Def 22
800 stu 24

   

  • Grep “moon”
Eno Ename Dno
100 Moon 12
200 Moon Soon 13

 

  • Grep - I “moon”
Eno Ename Dno
100 Moon 12
200 Monsoon 13
600 moon 20

 

  • Grep - w “moon”
Eno Ename Dno
100 Moon 12

 

  • Grep - v “moon”
Eno Ename Dno
300 Mani 14
400 Mani Kumar 16
500 Mani 18
600 Moon 20
700 Def 22
800 stu 24

  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

About Author
Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.