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 is abinitio?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
What is the max core of a component?
What are the primary keys and foreign keys?
What is sort component in abinitio?
In abinitio, what types of parallelism are used?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?
Can you explain the co>operating system’s processing model?
What is $mpjret?
Do you know what a local lookup is?
What do you mean by a transaction file and how it is different from that of a sort file?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
What exactly do you understand with the term data processing and businesses can trust this approach?
can we perform checkin and checkout through sandbox?
How to create a repository in abinitio for stand-alone system(local nt)?