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
- 24396 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
what is the output when -1 is put in select_expr of FBE?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
How to compare two dmls in abinitio
What is the syntax for m_dump in abinitio?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What is the purpose of having stored procedures in a database?
What the difference between “look-up” file and “look is up” in abinitio?
What is the ab initio business rules environment (bre)?
What is data mapping and data modelling?
What are the types of data processing you are familiar with?
What is a look-up?
What do you understand by a cartesian join?
How can we increase the loading performance of oracle table in AbInitio?
what is the project environment(for each project the environment is same or different to different project)?
