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
- 25162 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 are the features of ab initio?
how to insert/update a csv file by comparing it with another csv file?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
Mention some file extensions which are used in abinitio?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
How can you export a component’s internal parameters ?
Explain what does dependency analysis mean in abinitio?
What parallelisms does Abinitio support?
What is rollup component?
How you can run a graph infinitely in ab initio?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
How can you import XML repositories exported from different tools like ODI
What are differences between different versions of co-op?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
What is a deadlock and how it occurs?
