DataStage Tutorial

http://www.allwalkin.blogspot.com/http://www.allwalkin.blogspot.com/
what is Table Definition
Posted May 11th, 2010 by admin
What is Table Definition?
Ans). A definition describing the data you want to use. Each table definition contains information about the data table and the columns associated with it. Also referred to as meta data.
Posted in DataStage Interview Questions No Comments
what is data source
Posted May 11th, 2010 by admin
what is Data source?
Ans). A data source in DataStage terms means any database, whether you are extracting data from it or writing data to it.
Posted in DataStage Interview Questions No Comments
what is Data Source
Posted May 5th, 2010 by admin
http://www.allwalkin.blogspot.com/http://www.allwalkin.blogspot.com/
what is Data Source?
Ans). A data source in DataStage terms means any database, whether you are extracting data from it or writing data to it.
Posted in DataStage Interview Questions No Comments
what is DataStage Designer
Posted May 5th, 2010 by admin
what is DataStage Designer?
Ans). A graphical design tool used by the developer to design and develop a DataStage job.
Posted in DataStage Interview Questions No Comments
what is DataStage Manager
Posted May 5th, 2010 by admin
what is DataStage Manager?
Ans). A tool used by the developer to view and edit the contents of the Repository.

http://www.allwalkin.blogspot.com/http://www.allwalkin.blogspot.com/

What is Table Definition?
Ans). A definition describing the data you want to use. Each table definition contains information about the data table and the columns associated with it. Also referred to as meta data.
Posted in DataStage Interview Questions No Comments
Transform Function
Posted May 5th, 2010 by admin
Transform Function?
Ans). A function that takes one value and calculates another value from it.
Posted in DataStage Interview Questions No Comments
What is Data Aggregation

What is Data Aggregation?
http://www.allwalkin.blogspot.com/http://www.allwalkin.blogspot.com/
Ans). Data aggregation is the process used to group (sum) records. The summed (aggregated) total is stored in the data warehouse.
An operational data source usually contains records of individual transactions such as product sales. If the user of a data warehouse only needs a summed total, you can reduce many hundreds of records to a few by aggregating the data.
Because the number of records stored in the data warehouse is greatly reduced, it is easier for the end user to browse and analyze the data.
Posted in DataStage Interview Questions No Comments
What is Data Transformation
Posted May 5th, 2010 by admin
What is Data Transformation ?
Ans). Transformation is the process that converts data to a required definition and value.
Because the data in a data warehouse comes from many sources, the data may be in different formats or be inconsistent. Data is transformed using routines based on a transformation rule, for example, product codes can be mapped to a common format using a transformation rule that applies only to product codes.
http://www.allwalkin.blogspot.com/http://www.allwalkin.blogspot.com/
After data has been transformed it can be loaded into the data warehouse in a recognized and required format.
Posted in DataStage Interview Questions No Comments
What is Data Extraction
http://www.allwalkin.blogspot.com/http://www.allwalkin.blogspot.com/
What is Data Extraction ?
Data extraction : Data extraction is the process used to obtain data from operational sources, archives, and external data sources. The data in operational or archive systems is the primary source of data for the data warehouse. Operational databases can be indexed files, networked databases, or relational database systems is called as Data extraction.
What is Repository
Posted May 5th, 2010 by admin
What is Repository?
Repository: A DataStage area where projects and jobs are stored as well as definitions for all standard and user-defined data elements, transforms, and stages.
Posted in DataStage Interview Questions No Comments
What is the flow of loading data into fact and dimensional tables
http://www.allwalkin.blogspot.com/http://www.allwalkin.blogspot.com/
What is the flow of loading data into fact and dimensional tables?
Ans). Fact table – Table with Collection of Foreign Keys corresponding to he Primary Keys in Dimensional table. Consists of fields with numeric values.
Dimension Table – Table with Unique Primary Key.
Load – Data should be first loaded into dimensional table. Based on the Primary key values in dimensional table, the data should be loaded into Fact table.
Posted in DataStage Interview Questions No Comments
What is DataStage Engine
Posted May 3rd, 2010 by admin
What is DataStage Engine?
Ans). It is a JAVA engine running at the background.
Posted in DataStage Interview Questions No Comments
What is Snowflake schema
Posted May 3rd, 2010 by admin
What is Snowflake schema?
Ans). It is partially normalized dimensional model in which at two represents least one dimension or more hierarchy related tables.
Posted in DataStage Interview Questions No Comments
http://www.allwalkin.blogspot.com/http://www.allwalkin.blogspot.com/