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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do you need stage variables?

653


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

356


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1920


What are the repository tables in datastage?

817


Have you used Unstructured data?

824






Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2837


What is datastage engine?

726


What are the various kinds of the hash file?

655


What is the method of removing duplicates, without the remove duplicate stage?

576


What is active and passive stage?

872


Is possible to create skid in dim,fact tables?

2183


What is a ds designer?

636


what is use of SDR function?

4704


Differentiate between validated and Compiled in the Datastage?

631


What all the types of jobs you developed?

663