What is Datawarehouse| Datawarehouse Concepts| Explain Datawarehouse

Datawarehouse is a database which is used to store the heterogeneous sources of data with characteristics like a) Stucture Oriented b) Historical Information c)...

What is Sequential File Stage in Datastage?

Sequential file stage is a file stage which is used to read the data Sequentially or Parallely. If it is 1...

What is Dataset in Datastage? Uses of Dataset ?

Dataset is file stage, which is used for staging the data when we design dependent jobs. Dataset Supports 1 input link...

What is OLAP ( Online Analytical Process)

Online Analytical Process (OLTP) is a characterized by relatively low volume of transactions. Actually the queries are often very complex. In the OLAP...

What is Fact Tables in Datawarehousing ? Give Example?

Fact Table is an entity which represents the numerical measurements of any business. That means we create the fact tables for...

What is the importance of of Surrogate Key

Surrogate Key is a Primary Key for a dimensional table. ( Surrogate key is alternate to Primary Key) The...

What are the client components in Datastage 7.5X2 Version

In Datastage 7.5X2 Version, they are 4 client Components. They are 1) Datastage Designer 2) Datastage Director 3) Datastage Manager 4) Datastage Admin In Datastage Designer,...

In datastage, the data will be stored in which database.

First of all, the Datastage is first end tool, this is for designing jobs like parellel jobs etc. We create a folder in the...

Difference between Datastage 7.5X2 and Datastage 8.0.1 Versions

Difference between Datastage 7.5X2 and Datastage 8.0.1 Versions 1) In Datastage 7.5X2, there are 4 client components. They are a) Datastage Design b) Datastage Director c Datastage...

What is Datastage? Ascential Datastage? History of Datastage? What is Datastage ETL Tool?

What is Datastage? Ascential Datastage? History of Datastage? What is Datastage ETL Tool? Datastage is a comprehensive ETL Tool which provides end to end ERP...