How can you achieve scan using reformat ?
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 you can run a component for certain conditions ?
What do you mean by the overflow errors?
What is the difference between dml expression and xfr expression?
Code check-in and check-out commands in AbInitio
Have you worked with packages?
What is conduct>it?
What is the significance of record required indicator of Join component ? How to use in abinitio graph?
What is is a data flow graph?
what is the difference between the .dbc and .cfg extensions and give any clear information ?
Explain the methods to improve the performance of a graph?
How you can generate surrogate key? How to use in abinitio graph?
2 Answers IBM, TCL, Torry Harris,
Explain what is the architecture of abinitio?