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
- 25621 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
Explain what is de-partition in abinitio?
What exactly do you understand with the term data processing and businesses can trust this approach?
What are the different types of partition components in abinitio?
Mention some ways for improving performance of a graph?
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?
In abinitio, what types of parallelism are used?
what is the difference between i)public ii)private iii)common and client projects?
What is a rollup component?
How transaction file different from that of a sort file?
What is abinitio?
What is the syntax for m_dump in abinitio?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
What is conduct>it?
Within a cursor, how would you update fields on the row just fetched?
What is the ab initio business rules environment (bre)?
