Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ruknamw@yahoo.com
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 |
Post New Answer View All Answers
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
Explain data flow graph with an example?
What is the purpose of having stored procedures in a database?
Difference between output_index and output_indexes in reformat
Describe what the SQL Server tempdb and tlog files are used for?
Explain what is sandbox?
What are the different types of parallelism in ab initio?
What are the differences between informatica and abinitio?
Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low
Name the different type of processing based on the steps that you know about?
What are the facts that can compromise data integrity?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
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 abinitio eme is segregated?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
