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 do you add default rules in transformer?
What is data encoding?
Can you read multiple input files using one input file component ? (Same DML) How to use in abinitio graph?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
what is the difference between .dbc and .cfg file?
the inputs are 10,20,30,40,50 but the output was comes 0 records,the graph was failed what is bad situation?
i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.
how many types of project we can create in Abinitio? I mean public,private.......etc?
How data is processed and what are the fundamentals of this approach?
What are the different types of partition components in abinitio?
What are the different types of parallelism used in abinitio?
Can sorting and storing be done through single software or you need different for these approaches?