Hi friends,
I have 100 records in my input file, if i run first,the
first 10 records are stored into the output and if i run
second time next 10 records stored into the output file like
that
please let me know the answer
Thanks,
krishna
- 5 Answers
- 23735 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / jitender k
You can use I/F-->Reformat-->Rep-->Rollup-->lookup file
--> output_file
In reformat need to add next_in_sequence() >= lookup_match(lookup_file,count) and next_in_sequence() < lookup_match(lookup_file,count)+10
And in Rollup, we will have key as NULL and count function which will count the number of record process so far which stored in a separate file,so every time when your graphs runs it will pick from the next number of records.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Why might the optimizer use a table scan when an index is available?
What are the different forms of output that can be obtained after processing of data?
What does edp stand for?
Difference between output_index and output_indexes in reformat
Code check-in and check-out commands in AbInitio
Tell us about the architecture of abinitio.
What are the various types of layout supported by abinitio?
What is abinitio?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
Can sorting and storing be done through single software or you need different for these approaches?
What information is provided by .dbc file extension for connecting to the database?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
Explain what is de-partition in abinitio?
What is the ab initio business rules environment (bre)?
