A flatfile contains 200 records.I want to load first 50 records at first time r

A flatfile contains 200 records.I want to load first 50
records at first time running the job,second 50 records at
second time running and so on,how u can develop the job?pls
give the steps?

Question Posted / prasad

3 Answers
8712 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

A flatfile contains 200 records.I want to load first 50 records at first time running the job,secon..

Answer / srinu

flat file nothing but take sequence file use sed -n '1,50p'
using this command in filter option in the first running job.
second running job we use sed -n '51p,100' using this command
in this way we use other two times running job.....

Is This Answer Correct ?

8 Yes

1 No

A flatfile contains 200 records.I want to load first 50 records at first time running the job,secon..

Answer / vamsi

hi,
where we can get the rank function in datastag....

Is This Answer Correct ?

0 Yes

0 No

A flatfile contains 200 records.I want to load first 50 records at first time running the job,secon..

Answer / venky

first u use sequence generator for the flat file,after that
we take rank transformation in that take top as 50 records
and run the session 4 times it gives 200 records.

Is This Answer Correct ?

1 Yes

5 No

Post New Answer