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
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 are differences between different versions of co-op?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What is the difference between sandbox and EME?
Explain what is the architecture of abinitio?
What is common among data validity and data integrity?
What is $mpjret?
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
how to insert/update a csv file by comparing it with another csv file?
How co>operating system integrates with legacy codes?
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
How does the bre work with the co>operating system?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
Mention what information does a .dbc file extension provides to connect to the database?