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?

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

More Data Stage Interview Questions

Give an idea of system variables.

0 Answers  


I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  


how can we do null handling in sequential files

2 Answers   Reliance,


how to add a new records into source?

0 Answers  


What are the some differences between 7.x and 8.x version of datastage?

0 Answers  






what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,


How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  


I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,


WHAT are unix quentios in datastage

2 Answers   TCS,


Define APT_CONFIG in Datastage?

0 Answers  


Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,


How many types of hash files are there?

0 Answers  


Categories