Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 25206 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 a partition and what are the different types of partition components in abinitio?
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
What do you understand by local lookup?
List out some of the air commands used in abintio?
Mention what are the different types of parallelism used in abinitio?
What do you mean by the term data warehousing?
Do you know what a local lookup is?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
What are the differences between different versions of co-op?
Difference between output_index and output_indexes in reformat
What do you know about partition and also tell us about partition components in abinitio?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
Within a cursor, how would you update fields on the row just fetched?
What are the features of ab initio?
