Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How can you achieve scan using reformat ?

Answers were Sorted based on User's Feedback



How can you achieve scan using reformat ?..

Answer / 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

How can you achieve scan using reformat ?..

Answer / ai

Try using next_in_sequence()

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Ab Initio Interview Questions

what is difference between chk point n phase.Say im loading a file (containig 1 lakh records) and my graph fails after loading 50,000th record.What is the advantage of using check point in this case. Will i be able to start from 51000th record.

1 Answers   IBM,


How to connect mainframe to Abinitio?

1 Answers   CTS,


How does the bre work with the co>operating system?

0 Answers  


Describe the Evaluation of Parameters order.

1 Answers  


i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

0 Answers  


What do you know about abinitio?

0 Answers  


How we khow a database is connected in Abinitio?

2 Answers  


Hi friends i have 3 input files 1 is country file(cid,cname) 2 is State file(cid,sname) 3 is populate file(pid,sid,Adress) I want (cname & total poplation) how i can get the output please help me Thank you

1 Answers  


What is $mpjret? Where it is used in ab-initio?

4 Answers  


Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

0 Answers  


How will you use EME for view or publish metadata reports using EME?

1 Answers  


What is is a data flow graph?

0 Answers  


Categories