c2b_default

AVQ SWISSC

Question from AVQ Academy Part 2 - Englisch und Deutsch gemischt

Question from AVQ Academy Part 2 - Englisch und Deutsch gemischt

300
0.0 (0)

Kartei Details

Karten 300
Sprache Deutsch
Kategorie Informatik
Stufe Andere
Erstellt / Aktualisiert 11.03.2015 / 09.06.2017
Weblink
https://card2brain.ch/box/avq_swissc
Einbinden
<iframe src="https://card2brain.ch/box/avq_swissc/embed" width="780" height="150" scrolling="no" frameborder="0"></iframe>
Lernen
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.

What is an initial project?

An initial project is a project during which a bank (or banking–related enterprise) which does not yet use the Avaloq Banking System replaces its current system or parts thereof with the Avaloq Banking System.

What happens during an evaluation phase?

During the evaluation phase, the Avaloq Banking System is chosen as implementation package. During this phase functionality gaps may be identified.

How are releases and service packs delivered to the customer?

Releases are delivered via DVD, service packs are available for download in the Avaloq Community.

Étudier