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
- 25622 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
Explain the difference between the truncate and delete commands?
what is the difference between i)public ii)private iii)common and client projects?
How to run a graph infinitely?
Why do you think data processing is important?
What exactly do you know about the typical data analysis?
Explain the methods to improve performance of a graph?
What is the core of co> operating system?
What are the reasons for which business can trust the approach of data processing?
What does de-partition mean in abinitio?
Runtime behavior of Normalize and Reformat
List out some of the air commands used in abintio?
Code check-in and check-out commands in 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 are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
What is a deadlock and how it occurs?
