How can you achieve scan using reformat ?

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


Please Help Members By Posting Answers For Below Questions

Have you used the rollup component? Describe how?

882


Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com

2069


What will be the skew for, input file->partition by key-> partition by round robin->output file

652


What is a cursor? Within a cursor, how would you update fields on the row just fetched?

930


Why might you create a stored procedure with the with recompile option?

857


What is the architecture of abinitio?

873


What are the fundamental blocks of co> operating system of ab initio?

949


What are the facts that can compromise data integrity?

882


How to create repository in abinitio for stand alone system(local nt)?

960


Tell us about the architecture of abinitio.

876


Explain what is sandbox?

827


What do you understand by overflow errors?

882


What does it mean by the term 'sort component'?

873


Is data warehousing different from data mining?

842


Why might the optimizer use a table scan when an index is available?

2040