How can you achieve scan using reformat ?
- 2 Answers
- 11876 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 |
After completion of graph what is the next process to perform? who will perform the later process?
What is regex (lookup)? When you should use it?
. How we can remove temp files of a failed job if .rec is not available
How can I run the 2 gui merge files?
what are the steps in actual ab initio graph processing including general,pre and post process settings?
How co>operating system integrates with legacy codes?
Can you read multiple input files using one input file component ?(same DML)
explain checkin and checkout?
Tell us about the architecture of abinitio.
One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..
Can you read multiple input files using one input file component ? (Same DML) How to use in abinitio graph?
Mention what is a partition and what are the different types of partition components in abinitio?
Teradata 
