1
Q:

How to perform incremental load in DataStage? 

Answer:



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

3 43
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

3 43
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 698
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 858
Q:

What are the components of DataStage?

Answer

Datastage has two components


-Client Components – Designer, Director, Manager and Administrator


-Server Components – Server, Repository and Plug-ins.

Report Error

View answer Workspace Report Error Discuss

1 666