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 |
In MFS i developer developed 2-way, but supporters r supporting 4-way on same records how is possible?
How do you convert 4-way mfs to 8-way mfs?
If I delete 1 partition (in 8 partition multifile) and run the graph. Will the graph run successfully?, If not what error I'm going to get.
How to calculate total memory used my a graph?
Can you read multiple input files using one input file component ?(same DML)
How will you use EME for view or publish metadata reports using EME?
How can a graph be run infinitely?
How can you import XML repositories exported from different tools like ODI
What is the function that transfers a string into a decimal?
) How can you count the total no .of records in the specified partition in the Multifile?
How to implement the funtionality in the custom component to use in the graph?
What do you mean by a transaction file?