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)
Invisible
Invisible
Set of flashcards Details
Flashcards | 267 |
---|---|
Students | 149 |
Language | English |
Category | Computer Science |
Level | Other |
Created / Updated | 29.01.2013 / 20.05.2024 |
Licencing | No Copyright (CC0) |
Weblink |
https://card2brain.ch/box/avaloq_acp_dl
|
Embed |
<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