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

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

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.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.