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...

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...

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...

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...

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...

Difference between Server Jobs and Parallel Jobs

Difference between Server Jobs and Parallel Jobs Server Jobs works only if the server jobs datastage has...