Avaloq ACP (DL)
Self-made preparation questions for the "Avaloq Certified Professional" exam
Self-made preparation questions for the "Avaloq Certified Professional" exam
267
4.5 (4)
Non visible
Non visible
Fichier Détails
Cartes-fiches | 267 |
---|---|
Utilisateurs | 148 |
Langue | English |
Catégorie | Informatique |
Niveau | Autres |
Crée / Actualisé | 29.01.2013 / 30.11.2023 |
Attribution de licence | Pas de droit d'auteur (CC0) |
Lien de web |
https://card2brain.ch/box/avaloq_acp_dl
|
Intégrer |
<iframe src="https://card2brain.ch/box/avaloq_acp_dl/embed" width="780" height="150" scrolling="no" frameborder="0"></iframe>
|
A task consists of (source types)?
- a task definition (TASK DEF): what the task does
- a task template (TASK TEMPL): defines parameter list
Per task definition 1..n task templates.
Which layers does the Report Writer have?
- kernel layer: core programs to extract data from DB
- task definition: interface between the other two layers; flat datamart (DDIC)
- report definition: hierarchical datamart definition (REP DTM)
- layout definition (5 types)
Naming of flat datamarts?
- dtm_obj_<obj_type>
- dtm_doc_<transaction type>
How can a flat datamart be found?
Like any other data dictionary: Task and Reporting Desk, keyword "data dict"
Naming of hierarchical datamart (report datamart)?
- Example: task_pos_list.acad$my_report
- <task name>.<datamart name incl. NS>
Another name for report datamart?
Hierarchical datamart
Purpose of report datamart?
- provide data for layout including consolidation (sorting and grouping) and aggregation (calculations like sum)
Source type of hierarchical datamart?
REP DTM