#1
February 9th, 2016, 12:29 PM
| |||
| |||
What Is Data Stage in Data Warehousing
Hello, I want to open a warehouse and I want to know the details that what is data stage in data warehousing?
|
#2
February 9th, 2016, 02:21 PM
| |||
| |||
Re: What Is Data Stage in Data Warehousing
Hello, here I am providing you the details of the data stage used in data warehousing as under: Meaning of data stage: Data Stage is an integration tool, used in this space to perform the ETL for a data warehouse. It is essentially the data API into the warehouse. User Interface - usually a business intelligence reporting tool, such as Cognos or Microstrategy Data stage tutorial: Lesson 1 Data stage-modules - the lesson contains an overview of the data stage components and modules with screenshots. Lesson 2 Designing jobs – data stage palette - a list of all stages and activities used in Data stage Lesson 3 Extracting and loading data - ODBC and ORACLE stages - description and use of the ODBC and ORACLE stages (ORAOCI9) used for data extraction and data load. Covers ODBC input and output links, Oracle update actions and best practices. Lesson 4 Extracting and loading data - sequential files - description and use of the sequential files (flat files, text files, CSV files) in data stage. Lesson 5 Transforming and filtering data - use of transformers to perform data conversions, mappings, validations and data refining. Design examples of the most commonly used data stage jobs. Lesson 6 Performing lookups in Data stage - how to use hash files and database stages as a lookup source. Lesson 7 Implementing ETL process in Data stage - step by step guide on how to implement the ETL process efficiently in Data stage. Contains tips on how to design and run a set of jobs executed on a daily basis. Lesson 8 SCD implementation in Data stage - the lesson illustrates how to implement SCD's (slowly changing dimensions) in Data stage, contains job designs, screenshots and sample data. All the Slowly Changing Dimensions types are described in separate articles below: SCD Type 1 SCD Type 2 SCD Type 3 and 4 Lesson 9 Data stage jobs real-life solutions - a set of examples of job designs resolving real-life problems implemented in production data warehouse environments in various companies. Lesson 10 Header and trailer file processing - a sample Data stage job which processes a text file organized in a header and trailer format. |
|