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

How to find value from a column in a dataset?

0 Answers   TIAA CREF,


Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,


how to validate the jobs

2 Answers   IBM,


1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers   HCL,


IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  






What are the various kinds of containers available in datastage?

0 Answers  


detail about sdlc

4 Answers  


How to use Environment variable's in datastage?(use of process)

1 Answers   CSC,


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers   Alpharithm Technologies,


if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,


there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,


count number of deptno in a emp table?

2 Answers   IBM,


Categories