Answer Posted / ruknamw@yahoo.com
To create a simple sequence, the next_in_sequence() function can be used in a reformat.
In order to get cumulative summary, temporary variables can be used iteratively to increment a particular column by adding the previous value with the current value incrementally.
If a Key is involved, we need to ensure that the Key is sorted before the Reformat. A key change function using variables need to be written such that if the Key's current value is not equal to the previous value, the group has changed and the cumulative total needs to begin again with the current record value. If multiple columns make a key, the values can be concatenated for the key change verification.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is local and formal parameter?
What is abinitio?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
Mention what is a partition and what are the different types of partition components in abinitio?
What are the different types of parallelism used in abinitio?
What does de-partition mean in abinitio?
Describe in detail about lookup?
What is the purpose of having stored procedures in a database?
Explain the difference between the truncate and delete commands?
How do you improve the performance of a graph?
Explain data flow graph with an example?
How co> operating system natively processes the data?
How scientific data processing is different from commercial data processing?
What parallelisms does Abinitio support?
What is the role of co-operating system in abinitio?
