Introduction to Data Stage? What Is the Meta Data and Structure of Meta Data and Repository? Data Stage Enterprise Edition • Data Stage Client Software • Data Stage Server Software • Data Stage Client Components • Data Stage Server Components What is the Job and Data flow of Job and Types of Jobs? • Server Jobs • Client Jobs • Mainframe Jobs What is Difference between Server Job and Parallel Job? What is Stage and Types of stages? • Built – in Stage • Positive Stage • Database Stages • File Stages • Active Stages • Processing Stages • Plugging Stages Data Stage Project • Built in Components • Customized Components Data Properties • Table Def • Data Elements • Transforms NLS (National Language Support) • Creation of Project • Creation of Table Def Designing Simple Pass Job Defining the Source Stage Defining the Target Stage Defining the transfer Stage Running the Job Design Job with Filter Job Defining the Processing Stage Join Stage & Sort Stage What is Aggregator and how to define Aggregate Stage? What is Funnel Stage and types of Funnel Stages? • Continuous Funnel • Sort Funnel • Sequence Funnel What is Surrogate Key and how to generate surrogate key How to remove duplicates in Remove Stage Incremental Loading • Change Capture Stage • Modify Stage What is switch Stage and how to Generate Switch Stage What is Lookup Stage and how to Generate Lookup stage What is Merge Stage and how to Generate Merge Stage How to Generate Pivot Stage What is File Systems and types of File systems • Sequential File • Lookup File Set • File Set • Data Set Design Job with following Stages • Sequential File Stage • Dynamic RDBMS • Transformer Stage Design job with target as Dataset Design job with source as Dataset Development & Debugging Stages • Sample • Head • Tail • Row – Generate • Column Generate Meta Data Backup & Recovery Schedule the Job Add to Schedule How to Create Batch and Job Parameters How to define Target Stage and Transformer Stage Data Stage – SQL Override Define a Job with SQL Override – Filter • Join • Sorter What is Container and types of Containers? • Local Container • Shared Container • De-Contraction of container What is Job Sequence how to use the Job Sequence? What is Server jobs and how to use server jobs? Creation of ODBC DSN


