How can you achieve scan using reformat ?
- 2 Answers
- 12538 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
How do you improve the performance of a graph?
Mention some ways for improving performance of a graph?
What is the difference between look-up file and look-up, with a relevant example?
Name the different type of processing based on the steps that you know about?
After completion of graph what is the next process to perform? who will perform the later process?
Explain how you can run a graph infinitely in ab initio?
What is a partition and what are the different types of partition components in abinitio?
What are the kinds of layouts does ab initio supports?
What are the different versions and releases of ABinitio ?
Why might you create a stored procedure with the with recompile option?
) Layout? What is the Dataset & Program Component Layout
How does the bre work with the co>operating system?
Teradata 
