Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

Answer Posted / sushil

SeqFile---->Tranfrmr----->TGT
To number of rows in a sequential file in Transformer we
can use @INROWNUM, store value in variable ROW_NUM and then
by providing condition as same condition as:
ROW_NUM = '10' and ROW_NUM = '11' we can skip such records.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2226


Can you explain repository tables in datastage?

1340


What are the types of containers?

1141


What is a quality stage in datastage tool?

1023


Explain ibm infosphere information server and highlight its main features?

1034


What could be a data source system?

939


Explain the datastage parallel extender (px) or enterprise edition (ee)?

1171


What is the purpose of pivot stage?

1096


what are the errors,warnings in datastage

2619


What are orabulk and bcp stages?

1067


How many types of stage?

1131


How do y read Sequential file from job control?

15797


Differentiate between hash file and sequential file?

998


What is "fatal error/rdbms code 3996" error?

1190


explain about citrix scheduling tool in datastage

2379