Interested to Buy Any Domain ? << Click Here >> for more details...
How can you achieve scan using reformat ?
- 2 Answers
- 13303 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 |
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
What is use of creating a save files? How to use in abinitio graph?
1 Answers Cognizant, IBM, Intellego, TCL,
Hi friends, what are the new features in abinito3.0?
Difference between informatica vs ab initio?
What is is a data flow graph?
Mention what is abinitio?
Can you read multiple input files using one input file component ? (Same DML) How to use in abinitio graph?
What are the six data process products of ab initio (architecture of ab initio)?
What is dependent parameter ?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
What are the primary keys and foreign keys?
What do you know about partition and also tell us about partition components in abinitio?
Teradata 
