1
Q:

What is DataStage? 

Answer:



Q:

Which of the following is not a function of a Warehouse?

A) Ensuring Profit B) Stabilisation in price
C) Risk-bearing D) Storage
 
Answer & Explanation Answer: A) Ensuring Profit

Explanation:
Report Error

View Answer Report Error Discuss

1 2176
Q:

Define "Correlated Subqueries" ?

Answer

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.

Report Error

View answer Workspace Report Error Discuss

6 1915
Q:

Define what is a Fact, Dimension and Measure ?

Answer

Fact is key performance indicator to analyze the business.From the additive values, which are used to analyse the business by using report generation. Dimension is used to analyze the fact, are the non-additive ( text format) values, Which are used to drill down reports.Without dimension there is no meaning for fact. Measure is the quantity of data we create to process.

Report Error

View answer Workspace Report Error Discuss

5 2270
Q:

What does BUS Schema means ?

Answer

BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts.

Report Error

View answer Workspace Report Error Discuss

6 2555
Q:

State the difference between View and Materialized View ?

Answer

The main differenc between View and Materialized View states that -


1. View means it stores the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes.


2. Materialized view means it stores the results of the SQL in table form in the database. SQL statement only executes once and after that everytime you run the query, the stored result set is used. Advantage include quick query results.

Report Error

View answer Workspace Report Error Discuss

6 2984
Q:

What is the difference between operational data stage (ODS) and data warehouse?

Answer

Data warehouse


- It is a decision support database system for the purpose of organizational needs. 


-It is non volatile, integrated and time variant collection of data


 


Operational Data Stage


- It is an integrated collection of information. 


-It can contain 90 days of information at maximum.


-ODS supports dynamic data.

Report Error

View answer Workspace Report Error Discuss

1 3743
Q:

How to perform incremental load in DataStage?

Answer

-Daily loading is known as incremental load.


-When data is selected from source, selected records are loaded between timestamp of last load and the current time 


-The parameter that are passed to perform are last loaded date and current date


-The first parameter is the stored last run date is read through job parameters


-The second parameter is the current date

Report Error

View answer Workspace Report Error Discuss

1 6594
Q:

How do you generate Sequence number in Datastage?

Answer

Sequence numbers can be generated in Datastage using certain routines. They are


-KeyMgtGetNextVal


-KeyMgtGetNextValConn

Report Error

View answer Workspace Report Error Discuss

1 4747