Hi friends,
I have 100 records in my input file, if i run first,the
first 10 records are stored into the output and if i run
second time next 10 records stored into the output file like
that
please let me know the answer
Thanks,
krishna
- 5 Answers
- 23058 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pujan patra
Use partion by round robin and block size will be 10 .It
will give the desired output
| Is This Answer Correct ? | 19 Yes | 14 No |
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.
| Is This Answer Correct ? | 2 Yes | 1 No |
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. :)
| Is This Answer Correct ? | 6 Yes | 8 No |
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
| Is This Answer Correct ? | 1 Yes | 4 No |
Can you explain data flow graph with an example?
Describe the effect of the "checkpoint" t-sql statement?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What is the default layout of a component ? Is it mandatory to set the layout of a component ?
How do you add default rules in transformer?
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?
Is there any function in ab Initio which act like SCAN component
Can you explain the co>operating system’s processing model?
State the relation between EME, GDE and Co-operating system?
List out some of the air commands used in abintio?
Explain the ab initio etl tool in high level?
What are the different types of partition components in abinitio?
Teradata 
