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

How you can fix the truncated data error in datastage?

1887


How many types of hash files are there?

1234


What are the types of jobs we have in datastage?

1123


What is size of a transaction and an array means in a datastage?

1368


What are the steps required to kill the job in Datastage?

1269


how many rows sorted in sort stage by default in server jobs

4052


what is ds administrator used for?

1222


What is job control?

1200


What a datastage macro?

1103


How will you move hashed file from one location to another location?

2217


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2874


Where do you see different stages in the designer?

1146


Can you define merge?

1190


What are the types of containers in datastage?

1226


Define Merge?

1374