Interested to Buy Any Domain ? << Click Here >> for more details...
How can you achieve scan using reformat ?
- 2 Answers
- 13210 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 |
What is data encoding?
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
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
How might you quantitatively measure an improvement made to a query?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
What is the difference between a utility and api in a RUN SQL component
what is the use of stdenv in abinitio and what the main concept belongs to is?what is env?
What is meant by Co > Operating system and why it is special for Ab-initio ?
What are the factors on which storage of data depends?
What information does a .dbc file extension provides to connect to the database?
How do we handle if DML changing dynamicaly?
5 Answers GE, HP, IBM, Mannar Company,
What is max core value ? what is the use of it?
2 Answers JPMorgan Chase, Wipro,
Teradata 
