AVQ Zusammenfassung Homepage www.cram.com Teil 1

Karteikarten aus Seite http://www.cram.com/flashcards/export/2711515

Karteikarten aus Seite http://www.cram.com/flashcards/export/2711515


Set of flashcards Details

Flashcards 289
Language Deutsch
Category Computer Science
Level Other
Created / Updated 27.03.2015 / 08.05.2016
Weblink
https://card2brain.ch/box/avq_zusammenfassung_homepage_www_cram_com_teil_1
Embed
<iframe src="https://card2brain.ch/box/avq_zusammenfassung_homepage_www_cram_com_teil_1/embed" width="780" height="150" scrolling="no" frameborder="0"></iframe>
What are important PRCQ Groups, respectively PRCQ processors?

– Low Priority:, processed by BGP: PRCQ_1 (ID: 905)): 20 PRCQs, High Priority:, processed by BGP: PRCQ_2 (ID: 906)): 14 PRCQs, STEX (parallel processing):, processed by BGP: PRCQ_3 (ID: 907)): 6 PRCQs, Bulk orders and Security events:, processed by BGP

What differentiates the PRCQs processed by one BPG?

– Priority (1 = highest / 9 = lowest), Timeslot (period of time when the corresponding PRCQ entries are processed before the linked BGP switches to the next PRCQ)., The keep period: How long work requests are being retained., The user: Each PRCQ is ass

Currently, there are four (4) different entry points for parameterisation. Which ones are those?

OMDs, APIs, TOAD, Sources

List some disadvantages of direct table parameterisation through TOAD!

– Requires technical know how and detailed knowledge of table architecture., The parameterisation specialist needs to know the table architecture of Avaloq., Consistency is not guaranteed. E.g. a source may affect 10 tables or more., There is no contro

In which sequence of priorities appears the translation on an item? Consider not only the OUT_TEXT columns but also other table columns that you have been introduced to.

– text in column TEXT, TEXT_GE, TEXT_FR, … (respective session language), text defined in TEXT_XX (default language), text in column NAME

List an example where direct database parameterisation via TOAD is still done.

Translations for specific parts

Which columns are mandatory in a code table?

ID, USER_ID, INTL_ID, NAME, ACTIV

What is the purpose of ADT?

ADT is the external parameterisation repository of Avaloq. It also serves as backup of the parameterisation of the Avaloq Instance.

Is the parameterisation specialist writing PL/SQL code into the OMD sheet OMD_BP_CLASSIF.xls or simply meta data?

Meta data. The PL/SQL code is generated by the macros from Modules.xls (delivered by Avaloq).

Do rules affect the system behaviour?

Yes

To which source type do Object keys belong to?

Source Type Key Definition"."

To which source type do Additions belong to?

Source Types Code Table Data" and "Code Table Definition""

To which source type do Data Dictionaries belong to?

Source Type DDIC""

What is the risk in overwriting an Avaloq source?

The source may get overwritten by Avaloq with the next release.

What is the difference between the source status Corrupt and Error?

A source's state is Corrupt when it compiles without an error in Avaloq but Oracle returns an error. A source's state is Error when the Avaloq compiler returns an error.

How many Sources does a code table typically have?

– Table Definition, Table Data

Does a bank use only one Avaloq instance?

No, clients have always a source versioning system (ENV).

Does one source belong to several components?

No, a source belongs to one component only.

Is a source directly related to a change?

No, a source version always belongs to a change.

What do we need to do before closing a change?

We need to write the documentation.

Which are the views tin ENV hat show us the changes?

We may see them in the Change View, in the Expression View, in the Orderbook…

Can we modify an opened change? If yes, who can modify it?

All the granted users may modify the sources in a change.

Must a source be downloaded before compiling it?

No, we can compile it directly (remotely) on a DB.

Can I create new sources only?

No, we can create new versions (and modify) or close sources.

What search" option do we have via ENV/ADT that we do not have via the Avaloq client?"

Via the Avaloq Client we cannot look for information in sources without specifying more information.

Can we use ENV expressions to look for a source?

Yes, we can. This is for example what we do in the Expression View.

Give an example of a supplementary source type in ENV!

Business Type Config (BTC)

What is the difference between an API and an insert into" statement?"

APIs take care of triggers and are re–runnable.

How can we use a script to parameterise an instance?

For example, by running it via an SQL client.

BTC

Business Type Config

Is it enough to have saved a BTC source in ENV in order to parameterise an Avaloq instance?

No, we still have to compile that source on the selected Avaloq instance.

How can we track the modifications of a source?

By comparing two versions for example.

Which is the view that is based on the hierarchical structure between components, changes and sources?

That view is called the Expression View.

Clients have no possibility to reopen a change that has been closed? True or false?

True

May the same person close and audit a change? True or false?

It depends on the rights that that person was assigned.

Must the client use the (release–) boxes defined by Avaloq? True or false?

The boxes are a set of possibilities; Avaloq can implement more for the client.

ENV does not allow a customer to upgrade between two releases? True or false?

False: ENV allows it and makes it easier.

Does the Model Bank facilitate the first Avaloq implementation for a Bank? True or false?

Yes, it does.

What are the files that a bank receives for a release upgrade?

So called flat files"."

How are projects organized in teams, roles and responsibilities?

The project organisation shows how a project is organized and who is responsible for what. The project plan may show the responsibilities on a task level.