Technology Questions

SELECT statement has resulted in retrieval of more than one row.

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.

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

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.

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.

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

Following JavaScript objects are not accessible to web worker: 

- The window object

- The document object

- The parent object

Read - Reads users input, parse the input into JavaScript data-structure and stores in memory

Eval - Evaluates the data structure

Print - Prints the result

Loop - Loops the above command until user press ctrl-c twice