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
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 dedup-component and replicate component does?
State the working process of decimal_strip function?
What are the co> operating system’s assorted library of integrated components?
How scientific data processing is different from commercial data processing?
What do you mean by data sorting?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
How to create a repository in abinitio for stand-alone system(local nt)?
What is the difference between a scan component and a rollup component?
What is the purpose of having stored procedures in a data-based?
Do you think effective communication is necessary for data processing?
What are the facts that can compromise data integrity?
Can anyone give me an exaple of realtime start script in the graph?
What is the difference between dml expression and xfr expression?
Explain the ab initio etl tool in high level?
Why might you create a stored procedure with the with recompile option?