Tag: technology

Backup purposes

Storing intermediate results

Staging area for load operations

Sharing result data sets between applications

Designer

Workflow Manager

Workflow Monitor

All of above

Staging tables

Dimension Tables

Fact Tables

All of above

Designer

Workflow Manager

Workflow Monitor

Source Analyser

Schedule ETL,

Change Capture

Incremental/Full Load

All of above

Dimension is surrounded by Facts

Fact is surrounded by Dimensions

Dimension is surrounded by Dimensions

All of above

Data warehouse Admin Tool

Data Administration Console

Database Administration Console

Data warehouse Administration Console

SELECT lname, jobid, sal, sal+500 FROM emp;

SELECT lname, jobid, sal FROM emp (sal + 500);

SELECT lname, jobid, sal, sal + 500 “Bonus” FROM emp;

SELECT lname, jobid, sal, sal + 500 bonus FROM emp

SELECT lname || to_char(sal+500) “Employee Bonus” FROM emp;

SELECT lname, sal + 500 Employee Bonus FROM emp;

This is an equijoin.

This is a self join.

Line 2 will return an error.

Line 3 will return an error.

The statement will execute successfully.

True

False