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
- 24296 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pujan patra
Use partion by round robin and block size will be 10 .It
will give the desired output
| Is This Answer Correct ? | 19 Yes | 14 No |
Answer / 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 |
Answer / jerry
Hi,
You can create a graph with 2 parameters,say count1 and count2.
Now u can use a 'filter by' transform and give the filter
condition as
"next_in_sequence > count1 and next_in_sequence < count2".
U can give the value for parameters in the pset as 0,10
respectively.
this is just one way. :)
| Is This Answer Correct ? | 6 Yes | 8 No |
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 |
Mention what is the syntax for m_dump in abinitio?
What will be the output of using partition by Round-Robin after the partiton by key in ab initio?
How many parallelisms are in Abinitio?
One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
How to Create Surrogate Key using Ab Initio?
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
What is the difference between look-up file and look-up, with a relevant example?
Mention what is abinitio?
what is the difference between i)public ii)private iii)common and client projects?
What is m_dump?
What is air-project parameter ?
Teradata 
