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
Mention what is abinitio?
Explain the difference between the truncate and delete commands?
When we should use 'jobid' for commit table (Output table component??
what is the use of catlog or catlogfile?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
Do you know what a local lookup is?
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
What do you mean by a transaction file?
How do you add default rules in the transformer?
What is sort component in abinitio?
What are the benefits of data processing according to you?
What is the use of the co> operating system in ab initio?
What are the kinds of layouts does ab initio supports?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
Give one reason when you need to consider multiple data processing?
