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
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
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?
What are the benefits of data analyzing?
What are the six data process products of ab initio (architecture of ab initio)?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
Where $mpjret is used in ab-initio?
what is the project environment(for each project the environment is same or different to different project)?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What are the different types of partition components in abinitio?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
What are the different types of parallelism used in abinitio?
What is is a data flow graph?
What are “business rules” in ab initio business rules environment (bre)?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
Explain about ab initio’s dependency analysis?
What do you mean by the overflow errors?