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
what is the use of catlog or catlogfile?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
How transaction file different from that of a sort file?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What are the co> operating system’s assorted library of integrated components?
Mention some ways for improving performance of a graph?
Mention what information does a .dbc file extension provides to connect to the database?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
What is data encoding?
How can you force the optimizer to use a particular index?
What kind of layouts does abinitio support?
What are differences between different versions of co-op?
Mention what dedup-component and replicate component does?
Have you ever encountered an error called “depth not equal”?
Describe what the SQL Server tempdb and tlog files are used for?
