Interested to Buy Any Domain ? << Click Here >> for more details...
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
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
What is the role of co-operating system in abinitio?
What is a rollup component?
what is the difference between i)public ii)private iii)common and client projects?
What is the importance of eme in abinitio?
What are the differences between informatica and abinitio?
How data is processed and what are the fundamentals of this approach?
How you can run a graph infinitely in ab initio?
Describe what the SQL Server tempdb and tlog files are used for?
What will be the skew for, input file->partition by key-> partition by round robin->output file
What are “business rules” in ab initio business rules environment (bre)?
Explain what is sandbox?
Why might you create a stored procedure with the with recompile option?
What would be the next step after collecting the data?
How abinitio eme is segregated?
