Interested to Buy Any Domain ? << Click Here >> for more details...
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile.
Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is:
0th : 1,1,1
1st : 2,2
3rd : 3
4th : 4,4
What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ?
Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump
- 1 Answers
- 4890 Views
- I also Faced
- E-Mail Answers
Answer Posted / ram
AbInitio, next_in_sequence() function returns the next record in the sequence within a partition, while innovation_number() function returns the innovation number of the record, indicating its position in the sequence.Given the data you provided and assuming each record is numbered sequentially within each partition, the sequence of records when applying next_in_sequence() and innovation_number() would be:next_in_sequence(): 1, 1, 1, 2, 2, 3, 4, 4innovation_number(): 1, 2, 3, 1, 2, 1, 1, 2To extract the 3rd record from each of the 4 partitions of a 4-way multifile in AbInitio, you can use a combination of next_in_sequence() and conditional statements. Here's a basic outline of how you can achieve this:read_from_multifile(in = input_multifile) ->
begin
out :: output_table;
while(not end_of_file(input_multifile))
begin
record := next_in_sequence(input_multifile);
if innovation_number(input_multifile) = 3 then
out <- record;
end;
end;This script reads from the multifile and checks if the current record's innovation number is 3. If it is, the record is outputted to the output table. Repeat this process for all four partitions of the multifile.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What dedup-component and replicate component does?
Why might you create a stored procedure with the with recompile option?
Mention some ways for improving performance of a graph?
What is the use of the co> operating system in ab initio?
What are the steps to create a repository in ab initio?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
what is the output when -1 is put in select_expr of FBE?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
Explain what is de-partition in abinitio?
What parallelisms does Abinitio support?
How to create repository in abinitio for stand alone system(local nt)?
How does the bre work with the co>operating system?
What is the difference between a scan component and a rollup component?
