• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Filter’s & Data Set in Data Stage

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

For indepth understanding of DataStage click on

Summary
Review Date
Reviewed Item
Filter's & Data Set in Data Stage
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Filter's & Data Set in Data Stage"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.