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
- 25441 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / ruknamw@yahoo.com
Approach 1: Least Number of components. (only 3)
-----------
1. Declare a Parameter $COUNT to get the count of the Output file
2. Use that parameter in a FILTER BY EXPRESSION component after the input file. Use the below filter.
((next_in_sequence() + 1)/ 2 ) > $COUNT
and (next_in_sequence()/2 ) < (11 + $COUNT)
NOTE: The complicated logic above is used because of two next_in_sequence() functions which would be incremented by 2 for each record.
Alternative approach is to use a scan and local variables to create the sequence manually and use the appropriate filter. OR use two FILTER BY EXPRESSIONS, with the below filters:
next_in_sequence() > $COUNT
next_in_sequence() < 11
Approach 2:
-----------
1. Join the Output and Input file on all keys (or primary key if applicable)
2. Use a Filer component after the Unused port for the Input file. Filter should be next_in_sequence() < 11
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is brodcasting and replicate?
What is data mapping and data modelling?
What will be the skew for, input file->partition by key-> partition by round robin->output file
How data is processed and what are the fundamentals of this approach?
What is conduct>it?
What do you understand by overflow errors?
What are the six data process products of ab initio (architecture of ab initio)?
What is the max core of a component?
Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low
What information does a .dbc file extension provides to connect to the database?
What is the difference between rollup and scan?
What is the difference between partitioning with key / hash and round robin?
How to move or copy the project parameter or project object to my sandbox?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
How can we increase the loading performance of oracle table in AbInitio?
