Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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



Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Sup..

Answer / 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

More Ab Initio Interview Questions

Mention what the difference between “look-up” file and “look is up” in abinitio?

0 Answers  


How to compare two dmls in abinitio

0 Answers  


what is the difference between .dbc and .cfg file?

3 Answers   Cap Gemini,


What are the kinds of layouts does ab initio supports?

0 Answers  


What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?

0 Answers  


what are kinds of layouts does ab initio supports ?

4 Answers  


What will be the output of using partition by Round-Robin after the partiton by key in ab initio?

1 Answers  


How to load the data from an excel sheet to input file in a graph?

2 Answers   IBM,


What is local and formal parameter?

0 Answers  


What do you mean by the overflow errors?

0 Answers  


What is conditional DML and Structured DML?

2 Answers   Accenture,


How scientific data processing is different from commercial data processing?

0 Answers  


Categories