Answer / pujan patra

Use partion by round robin and block size will be 10 .It
will give the desired output

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.

Answer / nisanth

what is the key we need to give in lookup ?

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. :)

Answer / ruknamw@yahoo.com

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

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

1 Answers  

Mention what is rollup component?

0 Answers  

Can any body give the PDL with example?

1 Answers   Cap Gemini,

what is difference between chk point n phase.Say im loading a file (containig 1 lakh records) and my graph fails after loading 50,000th record.What is the advantage of using check point in this case. Will i be able to start from 51000th record.

1 Answers   IBM,

What is the difference between In-Memory Sort and Inputs must be sorted?

3 Answers  

What is meant by Co > Operating system and why it is special for Ab-initio ?

2 Answers  

Describe which system or process elements you would review when trouble-shooting general server slows ?

1 Answers  

Define ramp limit in ab initio?

0 Answers  

What do you understand by overflow errors?

0 Answers  

Give one reason when you need to consider multiple data processing?

0 Answers  

What are the different types of parallelism used in abinitio?

0 Answers  

Which Ab initio version has Hadoop connector ? and what is the latest GDE version available ?

1 Answers   Infosys, TCS,