Questions Ab Initio

  Single stage components process each record in a single step.Below are example of single stage component.  Filter by expression  Reformat  Dedup    Multi stage components process records in multiple stages allowing more complex operations like  initialisation,  finalization   Below are the example of the multi stage components    Normalize  Rollup  Scan  Scan with rollup etc.

  Answer 1:  When u load the data into a table in Utility mode all the constraints are disabled & then data is loaded which leads to faster access. During API Mode constraints will be enabled so that the access will be slow.   Answer 2: API & UTILITY are two possible interfaces to connect to the db’s to perform certain user specific tasks. These interfaces allow the user to access or use certain functions (provided by the db vendor) to perform operation on db’s. The functionality of each of these interfaces depends on  db’s. API has more flexibility but often considered as a slower process as compared to UTILITY mode. Well the trade off is their performance and usage.   Answer 3:   API mode is more diagnostic purpose for retrieving data from db means like selecting particular fields like retrieving the data relatively according to the constraints. Whenever we select API we will get the option of ablocal expression (ab_exp) every time where ever reco...