Technology Questions

BUS topology:

In this each computer is directly connected to primary network cable in a single line.

STAR topology:

In this all computers are connected using a central hub.

At the time of updating the data warehouse, a lookup table is used. When placed on the fact table or warehouse based upon the primary key of the target, the update is takes place only by allowing new records or updated records depending upon the condition of lookup.

The materialized views are aggregate tables. It contains summarized data. For example, to generate sales reports on weekly or monthly or yearly basis instead of daily basis of an application, the date values are aggregated into week values, week values are aggregated into month values and month values into year values. To perform this process aggregate function is used.

Catalog Manager supports command line options.

To move reports and dashboards, we need to use some general syntax using catalog manager.

e.g:

catalogmanager -online/offline

-cmd {report | replace | export}

{command line options}

In extra, by keeping it online, This will automatically open up the catalog 

manager without having the need to enter the connection details every time.

A Peoplesoft database is expression which point out a database containing Peoplesoft objects. For Oracle and only for Oracle, Peoplesoft consists in 3 schemas namely:

- PS (PSDBOWNER table owner),

- PEOPLE (for connection checking) and

- SYSADM (by default), the last one contains all the objects/data.

One of the database objects is connected with single Oracle schema, and all processes that connect to the database use the standard PSFT login procedure. PSFT login is used because to refer to the collection of tables in the administrative schema within an Oracle database. Every process that makes a 2-tier connection to the database identifies itself with a PSFT user or operator ID. Hence the interaction goes.

The primary keys of entity tables are the foreign keys of dimension tables.

The Primary keys of fact dimensional table are the foreign keys of fact tablels.

They get stored in System Catalog Views sys.server_principals and sys.sql_logins.

DLR is a runtime environment that allows you to integrate dynamic languages with the Common Language Runtime (CLR) by adding a set of services, such as expression trees, call site caching, and dynamic object interoperability to the CLR.

The System.Dynamic and System.Runtime.CompilerServices namespaces are used to hold the classes for DLR. It also provides dynamic features to statically-typed languages, such as C# and Visual Basic to enable their interoperation with dynamic languages.

VSAM acts as an interface between Application program & Operating System.