GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 35 of 140    Print  
how can we filter in sequential stage

  
Total Answers and Comments: 4 Last Update: February 21, 2007     Asked by: madycool 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: rajani
 
In the Filter option,u can use the UNIX command like this to filter the input records..

head -3 input_file.dat

Above answer was rated as good by the following members:
anilkumar.vanteru
August 30, 2006 02:12:02   #1  
sriranjan        

RE: how can we filter in sequential stage
we cant filter datas in sequential file.we can only filter the datas in database stage or in transformer stage.In database stage thru SQL statements we can filter.In tranformer filter conditions can be written in constraints.I don think so other than this steps we cant filter in datastage.
 
Is this answer useful? Yes | No
August 30, 2006 02:37:15   #2  
Dharmendra        

RE: how can we filter in sequential stage

Filter command. you can specify a filter program that will process the data before it is written to the file. This could be used for example to specify a zip program to compress the data. You can type in or browse for the filter program and specify any

command line arguments it requires in the text box. This text box is enabled only if you have selected the Stage uses filter commands checkbox on the Stage page General tab (see page 8-1). Note that if you specify a filter command data browsing is not available so the View Data button is disabled.


 
Is this answer useful? Yes | No
September 21, 2006 02:18:09   #3  
johney        

RE: how can we filter in sequential stage

The first solution is correct to some extent. But I thought there is a way as per the second solution. The second solution given is very clever I don't think the people are copying and paste the help content appearing in the DataStage (DataStage devs who doesn't know this... Think!). This is not a good practice. If you want to give right solutions with example then it will be helpful to the needful people.


 
Is this answer useful? Yes | No
February 21, 2007 04:37:17   #4  
rajani        

RE: how can we filter in sequential stage
In the Filter option u can use the UNIX command like this to filter the input records..

head -3 input_file.dat

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape