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
- 4771 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 is sandbox?
How would you find out whether a sql query is using the indices you expect?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
What do you mean by a transaction file?
State the relation between EME, GDE and Co-operating system?
What is the difference between partitioning with key / hash and round robin?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
What is the max core of a component?
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
Have you used rollup component? Describe how.
How can we increase the loading performance of oracle table in AbInitio?
Explain what does dependency analysis mean in abinitio?
What kind of layouts does abinitio support?
How do you truncate a table?
