Difference data

Data Stage Course Content at Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in Data Stage Data Stage Course Content at Learning Hub Contents • Introduction about Data Stage • Difference between Server Jobs and Parallel Jobs • Difference between Pipeline Parallelisms • Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,Range,DB2,Auto) • Configuration File • Difference between SMP/MPD architecture • Data Stage Components (Server components/Client Components) • Package Installer Data Stage Administrator • Creating project, Editing project and Deleting project • Permissions to user • .Apt Config file • Environment variable creation, permission Data stage director • Introduction to Data stage Director • Job status View • View logs • Scheduling • Batches Creation Designer • Introduction about Designer • Repository • Palatte • Types of Links • File Stages • Sequential File • Data set File • Lookup file set • Difference between Sequential file/Dataset/File set • Database stages • Dynamic RDBMS • Oracle Enterprise • ODBC Enterprise • Stored Procedure Processing stages • Change Capture (Caption) • Compare stage • Difference Stage • Aggregate Stage • Transformer Stage • Surrogate Generator Stage • Join Generator Stage • Merge Generator Stage • Lookup Generator Stage • Difference between join/Lookup/Merge • Difference between join/Lookup • Remove Duplicates • Switch • Pivot • Modify • Funnel Debugging stage • Head • Tail • Pea • Row Generator • Column Generator • Sample • Job Parameters Manager • Introduction About Data stage Manager • Importing the Job • Exporting the Job • Importing Table Definition • Importing Flat File Definition • Routines Containers • Difference between Local Container and Shared Container • Local Container • Shared Container Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in Data Stage Online Training, Data Stage Class Room Training, Data Stage Training in Magarpatta City, Data Stage Jobs and Placement, Data Stage Remote Support, Data Stage Online Help,Data Stage Videos training, Data Stage training by Learning Hub, Fast track classes in Data Stage, Best Data Stage training institutes in Pune, Best Faculty in Data Stage, Best online Faculty in Data Stage, Professional classroom training in Data Stage, Professional online training in Data Stage,Data Stage Certification, Data Stage training in Dubai, Data StageTraining in Melbourne, Data Stage Training in Dubai, Data Stage Training, Data Stage Training,Data Stage Training, Data StageOnline Training, Data Stage certfication and suppor

DATA STAGE TRAINING IN CHENNAI FOR MNC PROFESSIONALS Peridot Systems is only Data stage training In Chennai delivering the best training for students and also a carrier oriented training . Peridot Systems is a pioneer name in Training, Development, and provides one stop IT professional trainings. We provide trainings in ERP, Java, .net, SQT, SharePoint, Linux, Ms-BI, Cloud computing and all other latest technologies. Peridot Systems aspires to facilitate the creation of a network of IT Training Institutes worldwide to empower the workforce with job oriented skills. Selected Individuals and companies that share the passion and vision of Peridot Systems.  Preferable Timinings  Free Software Installation  One Year Tech Support  Real Time Trainers Data Stage Course Content Data ware housing concepts v About data warehousing v History of data warehousing v Data warehousing architecture v Different Data marts v Advantages of DWH v Properties of DWH v OLTP VS OLAP v DWH Approaches v Data Modeling v Star, Snowflake & Galaxy Schemas v Dimension tables v Fact Tables Data Stage Contents Introduction about Data Stage IBM Information server overview IBM Web sphere Data stage and information Analyzer IBM Web sphere Quality stage Difference between Server Jobs and Parallel Jobs Difference between Pipeline and partitioning Parallelisms Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules, Range, DB2, Auto) Configuration File Difference between SMP, MPP, Cluster architecture Data Stage Components (Server components/Client Components) Package Installer 1.Data Stage Administrator • 2.Data stage director 3.Designer 4.Processing stages For Further Details Please Contact 9790855020 Venue Details: Peridot Systems Kamatchi Krupa Apts, No: 84/8, Ground Floor, Venkatarathinam main street, Venkatarathinam Nagar, LB Road, Adyar, Chennai. Tamil Nadu - 600020.

DATA STAGE TRAINING IN CHENNAI FOR MNC PROFESSIONALS Peridot Systems is only Data stage training In Chennai delivering the best training for students and also a carrier oriented training. Peridot Systems is a pioneer name in Training, Development, and provides one stop IT professional trainings. We provide trainings in ERP, Java,.net, SQT, SharePoint, Linux, Ms-BI, Cloud computing and all other latest technologies. Peridot Systems aspires to facilitate the creation of a network of IT Training Institutes worldwide to empower the workforce with job oriented skills. Selected Individuals and companies that share the passion and vision of Peridot Systems. Preferable Timinings Free Software Installation One Year Tech Support Real Time Trainers Data Stage Course Content Data ware housing concepts v About data warehousing v History of data warehousing v Data warehousing architecture v Different Data marts v Advantages of DWH v Properties of DWH v OLTP VS OLAP v DWH Approaches v Data Modeling v Star, Snowflake & Galaxy Schemas v Dimension tables v Fact Tables Data Stage Contents Introduction about Data Stage IBM Information server overview IBM Web sphere Data stage and information Analyzer IBM Web sphere Quality stage Difference between Server Jobs and Parallel Jobs Difference between Pipeline and partitioning Parallelisms Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules, Range, DB2, Auto) Configuration File Difference between SMP, MPP, Cluster architecture Data Stage Components (Server components/Client Components) Package Installer 1.Data Stage Administrator • 2.Data stage director 3.Designer 4.Processing stages For Further Details Please Contact Venue Details: Peridot Systems Kamatchi Krupa Apts, No: 84/8, Ground Floor, Venkatarathinam main street, Venkatarathinam Nagar, LB Road, Adyar, Chennai. Tamil Nadu - .

We are a team of online trainers, providing online training for maxonlinetraining,major Data warehousing courses and latest Information Technology courses. Our maxonlinetraining trainers are subject experts, Industry experienced and real time workers. Our online training will enable you to master,data warehousing and latest Information Technology courses. You are welcome to attend our free demo classes for knowing more about the maxonlinetraining course. maxonlinetraining,bi reporting tool,classes,course,tutorial,jobs,placements,usa,Canada Call us at For any queries, please contact: +1 940 440 8084 / +91 953 383 7156 TODAY to join our Online IT Training course & find out how Max Online Training.com can help you embark on an exciting and lucrative IT career. TODAY to join our Online IT Training course & find out how Max Online Training.com can help you embark on an exciting and lucrative IT career.

WARM WELCOME FROM VELGRO TECHNOLOGIES!!! We are providing training for DATA WAREHOUSE Training is provided by well experienced (REAL TIME) Faculty!!! Fee structure Course fees: RS./- Data Warehouse The Compelling Need for Data Warehousing • Escalating Need for Strategic Information • Failures of Past Decision-Support Systems • Operational Versus Decision-Support Systems • Datawarehousing—The Only Viable Solution • Datawarehouse Defined • The Datawarehousing Movement • Evolution of Business Intelligence Data Warehouse: The Building Blocks • Review formal definitions of a data warehouse • Discuss the defining features • Distinguish between data warehouses and data marts • Study each component or building block that makes up a data warehouse • Introduce metadata and highlight its significance Trends in Data Warehousing • Data Warehouse Do-Overs • Proliferation of Data Sources • Outsourcing • Hub Versus Relational Databases • Active Data Warehouses • Fusion with CRM • Growing Number of End Users • More Complex Queries • Integrated Customer View • Exploding Data Volumes Planning and Project Management • Phases in project management • Inception • Elaboration • Construction • Transition Defining the Business Requirements • To gain agreement with stakeholders • To provide a foundation to communicate to a technology service provider what the solution needs to do to satisfy the customer’s and business’ needs • To provide input into the next phase for this project • To describe what not how the customer/business needs will be met by the solution Requirements as the driving force for data warehousing • Understand why business requirements are the driving force • Discuss how requirements drive every development phase • Specifically learn how requirements influence data design • Review the impact of requirements on architecture • Note the special considerations for ETL and metadata • Examine how requirements shape information delivery The Architectural Components • Overall Architecture • Data Warehouse Database • Sourcing, Acquisition, Cleanup and Transformation Tools • Meta data • Data Marts • Data Warehouse Administration and Management Infrastructure as the Foundation for Data Warehousing • Understand the distinction between architecture and infrastructure • Find out how the data warehouse infrastructure supports its architecture • Gain an insight into the components of the physical infrastructure • Review hardware and operating systems for the data warehouse • Study parallel processing options as applicable to the data warehouse • Discuss the server options in detail • Learn how to select the DBMS • Review the types of tools needed for the data warehouse • Study the concept and use of data warehouse appliances The Significant Role of Metadata • Find out why metadata is so important • Understand who needs metadata and what types they need • Review metadata types by the three functional areas • Discuss business metadata and technical metadata in detail • Examine all the requirements metadata must satisfy • Understand the challenges for metadata management • Study options for providing metadata Principles of Dimensional Modelling • Clearly understand how the requirements definition determines data design • Introduce dimensional modelling and contrast it with entity-relationship modelling • Review the basics of the STAR schema • Find out what is inside the fact table and inside the dimension tables • Determine the advantages of the STAR schema for data warehouses Dimensional Modelling: Advanced Topics • Discuss and get a good grasp of slowly changing dimensions • Understand large dimensions and how to deal with them • Examine the snowflake schema in detail • Learn about aggregate tables and determine when to use them • Completely survey families of STARS and their application Data Extraction, Transformation, and Loading • Part I: When to build your data warehouse • Part II: Building a new schema • Part III: Location of your data warehouse The Physical Design Process in DWH • Distinguish between physical design and logical design as applicable to the data warehouse • Study the steps in the physical design process in detail • Understand physical design considerations and know the implications • Grasp the role of storage considerations in physical design • Examine indexing techniques for the data warehouse environment • Review and summarize all performance enhancement options • Matching Information to the Classes of Users OLAP in the Data Warehouse • OLAP (Online Analytical Processing) • Overview & Introduction • OLAP Cube • HISTORY of OLAP • OLAP Operations • DATAWAREHOUSE • ARCHITECHTURE Difference between OLAP & • OLTP & TYPES OF OLAP APPLICATIONS OF OLAP • Data Warehousing and the Web • Data Warehouse Deployment • Data Quality: A Key to Success • Data Mining Basics • Growth and Maintenance contact person: SUJITHA Venue Address: #st floor,Gandhi Road, Velachery Email Id:velgrotechnologies at gmail dot com info at velgrotechnologies dot com Website:www dot velgrotechnologies dot com

OBIEE 11g, OBIEE 10g, Siebel Analytics,Obia Dac Data warehouse Concepts · Data warehouse · Data mart · Basics of Data Warehousing · What is OLTP and OLAP? · Difference between OLTP and OLAP · Dimensional Modeling Overview · Introduction to Dimensional Modeling · Dimensional table · Fact table · Aggregate table · Star schema · Snowflake schema · Star schema Vs. Snowflake schema · Fact Vs. Dimension table · Fact Vs. Aggregate Table · Types of Facts · Types of Fact tables · Types of Dimensions · Level of Granularity · Grain of fact · Slowly Changing Dimensions(SCD) · Normalization · DE normalization OBIEE Overview · Introduction to Siebel Analytics · Introduction to OBIEE 10 G · What is Obiee? · Advantages of Obiee · End to End Life Cycle of Obiee · Types of Reports · Types of Applications · Components OF Obiee · Client Components Of Obiee · Obiee Architecture · Difference between Obiee 10g and Siebel Analytics · Difference between Obiee 10g

Description for "Oracle OBIEE corporate training in India" OBIEE 11g, OBIEE 10g, Siebel Analytics,Obia Dac sadguru technologies 040-- Data warehouse Concepts · Data warehouse · Data mart · Basics of Data Warehousing · What is OLTP and OLAP? · Difference between OLTP and OLAP · Dimensional Modeling Overview · Introduction to Dimensional Modeling · Dimensional table · Fact table · Aggregate table · Star schema · Snowflake schema · Star schema Vs. Snowflake schema · Fact Vs. Dimension table · Fact Vs. Aggregate Table · Types of Facts · Types of Fact tables · Types of Dimensions · Level of Granularity · Grain of fact · Slowly Changing Dimensions(SCD) · Normalization · DE normalization OBIEE Overview · Introduction to Siebel Analytics · Introduction to OBIEE 10 G · What is Obiee? · Advantages of Obiee · End to End Life Cycle of Obiee · Types of Reports · Types of Applications · Components OF Obiee · Client Components Of Obiee · Obiee Architecture · Difference between Obiee 10g and Siebel Analytics · Difference between Obiee 10g

Description for "Oracle OBIEE corporate training in India" OBIEE 11g , OBIEE 10g , Siebel Analytics ,Obia Dac Data warehouse Concepts · Data warehouse · Data mart · Basics of Data Warehousing · What is OLTP and OLAP? · Difference between OLTP and OLAP · Dimensional Modeling Overview · Introduction to Dimensional Modeling · Dimensional table · Fact table · Aggregate table · Star schema · Snowflake schema · Star schema Vs. Snowflake schema · Fact Vs. Dimension table · Fact Vs. Aggregate Table · Types of Facts · Types of Fact tables · Types of Dimensions · Level of Granularity · Grain of fact · Slowly Changing Dimensions( SCD ) · Normalization · DE normalization OBIEE Overview · Introduction to Siebel Analytics · Introduction to OBIEE 10 G · What is Obiee? · Advantages of Obiee · End to End Life Cycle of Obiee · Types of Reports · Types of Applications · Components OF Obiee · Client Components Of Obiee · Obiee Architecture · Difference between Obiee 10g and Siebel Analytics · Difference between Obiee 10g

​Description for "Oracle OBIEE corporate training in India" OBIEE 11g , OBIEE 10g , Siebel Analytics ,Obia Dac sadguru technologies 040-40154733-8179736190 Data warehouse Concepts · Data warehouse · Data mart · Basics of Data Warehousing · What is OLTP and OLAP? · Difference between OLTP and OLAP · Dimensional Modeling Overview · Introduction to Dimensional Modeling · Dimensional table · Fact table · Aggregate table · Star schema · Snowflake schema · Star schema Vs. Snowflake schema · Fact Vs. Dimension table · Fact Vs. Aggregate Table · Types of Facts · Types of Fact tables · Types of Dimensions · Level of Granularity · Grain of fact · Slowly Changing Dimensions( SCD ) · Normalization · DE normalization OBIEE Overview · Introduction to Siebel Analytics · Introduction to OBIEE 10 G · What is Obiee? · Advantages of Obiee · End to End Life Cycle of Obiee · Types of Reports · Types of Applications · Components OF Obiee · Client Components Of Obiee · Obiee Architecture · Difference between Obiee 10g and Siebel Analytics · Difference between Obiee 10g

FOR FREE DEMO contact us at: Phone/WhatsApp: +91-(850) 012-2107 HADOOP ONLINE TRAINING BY REALTIME CORPORATE PROFESSIONALS Hadoop Course Content (we can customize the course content as per your requirement) HADOOP Using Cloudera Development & Admin Course Introduction to BigData, Hadoop:- • Big Data Introduction • Hadoop Introduction • What is Hadoop? Why Hadoop? • Hadoop History? • Different types of Components in Hadoop? • HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on… • What is the scope of Hadoop? Deep Drive in HDFS (for Storing the Data):- • Introduction of HDFS • HDFS Design • HDFS role in Hadoop • Features of HDFS • Daemons of Hadoop and its functionality • Name Node • Secondary Name Node • Job Tracker • Data Node • Task Tracker • Anatomy of File Wright • Anatomy of File Read • Network Topology • Nodes • Racks • Data Center • Parallel Copying using DistCp • Basic Configuration for HDFS • Data Organization • Blocks and • Replication • Rack Awareness • Heartbeat Signal • How to Store the Data into HDFS • How to Read the Data from HDFS • Accessing HDFS (Introduction of Basic UNIX commands) • CLI commands MapReduce using Java (Processing the Data):- • Introduction of MapReduce. • MapReduce Architecture • Data flow in MapReduce • Splits • Mapper • Portioning • Sort and shuffle • Combiner • Reducer • Understand Difference Between Block and InputSplit • Role of RecordReader • Basic Configuration of MapReduce • MapReduce life cycle • Driver Code • Mapper • and Reducer • How MapReduce Works • Writing and Executing the Basic MapReduce Program using Java • Submission & Initialization of MapReduce Job. • File Input/output Formats in MapReduce Jobs • Text Input Format • Key Value Input Format • Sequence File Input Format • NLine Input Format • Joins • Map-side Joins • Reducer-side Joins • Word Count Example • Partition MapReduce Program • Side Data Distribution • Distributed Cache (with Program) • Counters (with Program) • Types of Counters • Task Counters • Job Counters • User Defined Counters • Propagation of Counters • Job Scheduling PIG:- • Introduction to Apache PIG • Introduction to PIG Data Flow Engine • MapReduce vs PIG in detail • When should PIG used? • Data Types in PIG • Basic PIG programming • Modes of Execution in PIG • Local Mode and • MapReduce Mode • Execution Mechanisms • Grunt Shell • Script • Embedded • Operators/Transformations in PIG • PIG UDF’s with Program • Word Count Example in PIG • The difference between the MapReduce and PIG SQOOP:- • Introduction to SQOOP • Use of SQOOP • Connect to mySql database • SQOOP commands • Import • Export • Eval • Codegen and etc… • Joins in SQOOP • Export to MySQL HIVE:- • Introduction to HIVE • HIVE Meta Store • HIVE Architecture • Tables in HIVE • Managed Tables • External Tables • Hive Data Types • Primitive Types • Complex Types • Partition • Joins in HIVE • HIVE UDF’s and UADF’s with Programs • Word Count Example HBASE:- • Introduction to HBASE • Basic Configurations of HBASE • Fundamentals of HBase • What is NoSQL? • HBase DataModel • Table and Row • Column Family and Column Qualifier • Cell and its Versioning • Categories of NoSQL Data Bases • Key-Value Database • Document Database • Column Family Database • SQL vs NOSQL • How HBASE is differ from RDBMS • HDFS vs HBase • Client side buffering or bulk uploads • HBase Designing Tables • HBase Operations • Get • Scan • Put • Delete MongoDB:-- • What is MongoDB? • Where to Use? • Configuration On Windows • Inserting the data into MongoDB? • Reading the MongoDB data. Cluster Setup:-- • Downloading and installing the Ubuntu12.x • Installing Java • Installing Hadoop • Creating Cluster • Increasing Decreasing the Cluster size • Monitoring the Cluster Health • Starting and Stopping the Nodes OOZIE • Introduction to OOZIE • Use of OOZIE • Where to use? Hadoop Ecosystem Overview Oozie HBase Pig Sqoop Casandra Chukwa Mahout Zoo Keeper Flume • Case Studies Discussions • Certification Guidance • Real Time Certification and • interview Questions and Answers • Resume Preparation • Providing all Materials nd Links • Real time Project Explanation and Practice Phone/WhatsApp: +91-(850) 012-2107

BIGDATA –HADOOP REALTIME TRAINING,JOB SUPPORT,INTERVIEW SUPPORT BY HANDS-ON EXPERTS Phone/WhatsApp: +91-(850) 012-2107 Course Content HADOOP Using Cloudera Development & Admin Course Introduction to BigData, Hadoop:- • Big Data Introduction • Hadoop Introduction • What is Hadoop? Why Hadoop? • Hadoop History? • Different types of Components in Hadoop? • HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on… • What is the scope of Hadoop? Deep Drive in HDFS (for Storing the Data):- • Introduction of HDFS • HDFS Design • HDFS role in Hadoop • Features of HDFS • Daemons of Hadoop and its functionality • Name Node • Secondary Name Node • Job Tracker • Data Node • Task Tracker • Anatomy of File Wright • Anatomy of File Read • Network Topology • Nodes • Racks • Data Center • Parallel Copying using DistCp • Basic Configuration for HDFS • Data Organization • Blocks and • Replication • Rack Awareness • Heartbeat Signal • How to Store the Data into HDFS • How to Read the Data from HDFS • Accessing HDFS (Introduction of Basic UNIX commands) • CLI commands MapReduce using Java (Processing the Data):- • Introduction of MapReduce. • MapReduce Architecture • Data flow in MapReduce • Splits • Mapper • Portioning • Sort and shuffle • Combiner • Reducer • Understand Difference Between Block and InputSplit • Role of RecordReader • Basic Configuration of MapReduce • MapReduce life cycle • Driver Code • Mapper • and Reducer • How MapReduce Works • Writing and Executing the Basic MapReduce Program using Java • Submission & Initialization of MapReduce Job. • File Input/output Formats in MapReduce Jobs • Text Input Format • Key Value Input Format • Sequence File Input Format • NLine Input Format • Joins • Map-side Joins • Reducer-side Joins • Word Count Example • Partition MapReduce Program • Side Data Distribution • Distributed Cache (with Program) • Counters (with Program) • Types of Counters • Task Counters • Job Counters • User Defined Counters • Propagation of Counters • Job Scheduling PIG:- • Introduction to Apache PIG • Introduction to PIG Data Flow Engine • MapReduce vs PIG in detail • When should PIG used? • Data Types in PIG • Basic PIG programming • Modes of Execution in PIG • Local Mode and • MapReduce Mode • Execution Mechanisms • Grunt Shell • Script • Embedded • Operators/Transformations in PIG • PIG UDF’s with Program • Word Count Example in PIG • The difference between the MapReduce and PIG SQOOP:- • Introduction to SQOOP • Use of SQOOP • Connect to mySql database • SQOOP commands • Import • Export • Eval • Codegen and etc… • Joins in SQOOP • Export to MySQL HIVE:- • Introduction to HIVE • HIVE Meta Store • HIVE Architecture • Tables in HIVE • Managed Tables • External Tables • Hive Data Types • Primitive Types • Complex Types • Partition • Joins in HIVE • HIVE UDF’s and UADF’s with Programs • Word Count Example HBASE:- • Introduction to HBASE • Basic Configurations of HBASE • Fundamentals of HBase • What is NoSQL? • HBase DataModel • Table and Row • Column Family and Column Qualifier • Cell and its Versioning • Categories of NoSQL Data Bases • Key-Value Database • Document Database • Column Family Database • SQL vs NOSQL • How HBASE is differ from RDBMS • HDFS vs HBase • Client side buffering or bulk uploads • HBase Designing Tables • HBase Operations • Get • Scan • Put • Delete MongoDB:-- • What is MongoDB? • Where to Use? • Configuration On Windows • Inserting the data into MongoDB? • Reading the MongoDB data. Cluster Setup:-- • Downloading and installing the Ubuntu12.x • Installing Java • Installing Hadoop • Creating Cluster • Increasing Decreasing the Cluster size • Monitoring the Cluster Health • Starting and Stopping the Nodes OOZIE • Introduction to OOZIE • Use of OOZIE • Where to use? Hadoop Ecosystem Overview Oozie HBase Pig Sqoop Casandra Chukwa Mahout Zoo Keeper Flume • Case Studies Discussions • Certification Guidance • Real Time Certification and • interview Questions and Answers • Resume Preparation • Providing all Materials nd Links • Real time Project Explanation and Practice

BEST HADOOP LIVE TRAINING BY REALTIME CORPORATE PROFESSIONALS Hadoop Course Agenda (we can customize the course content as per your requirement) HADOOP Using Cloudera Development & Admin Course Introduction to BigData, Hadoop:- • Big Data Introduction • Hadoop Introduction • What is Hadoop? Why Hadoop? • Hadoop History? • Different types of Components in Hadoop? • HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on… • What is the scope of Hadoop? Deep Drive in HDFS (for Storing the Data):- • Introduction of HDFS • HDFS Design • HDFS role in Hadoop • Features of HDFS • Daemons of Hadoop and its functionality • Name Node • Secondary Name Node • Job Tracker • Data Node • Task Tracker • Anatomy of File Wright • Anatomy of File Read • Network Topology • Nodes • Racks • Data Center • Parallel Copying using DistCp • Basic Configuration for HDFS • Data Organization • Blocks and • Replication • Rack Awareness • Heartbeat Signal • How to Store the Data into HDFS • How to Read the Data from HDFS • Accessing HDFS (Introduction of Basic UNIX commands) • CLI commands MapReduce using Java (Processing the Data):- • Introduction of MapReduce. • MapReduce Architecture • Data flow in MapReduce • Splits • Mapper • Portioning • Sort and shuffle • Combiner • Reducer • Understand Difference Between Block and InputSplit • Role of RecordReader • Basic Configuration of MapReduce • MapReduce life cycle • Driver Code • Mapper • and Reducer • How MapReduce Works • Writing and Executing the Basic MapReduce Program using Java • Submission & Initialization of MapReduce Job. • File Input/output Formats in MapReduce Jobs • Text Input Format • Key Value Input Format • Sequence File Input Format • NLine Input Format • Joins • Map-side Joins • Reducer-side Joins • Word Count Example • Partition MapReduce Program • Side Data Distribution • Distributed Cache (with Program) • Counters (with Program) • Types of Counters • Task Counters • Job Counters • User Defined Counters • Propagation of Counters • Job Scheduling PIG:- • Introduction to Apache PIG • Introduction to PIG Data Flow Engine • MapReduce vs PIG in detail • When should PIG used? • Data Types in PIG • Basic PIG programming • Modes of Execution in PIG • Local Mode and • MapReduce Mode • Execution Mechanisms • Grunt Shell • Script • Embedded • Operators/Transformations in PIG • PIG UDF’s with Program • Word Count Example in PIG • The difference between the MapReduce and PIG SQOOP:- • Introduction to SQOOP • Use of SQOOP • Connect to mySql database • SQOOP commands • Import • Export • Eval • Codegen and etc… • Joins in SQOOP • Export to MySQL HIVE:- • Introduction to HIVE • HIVE Meta Store • HIVE Architecture • Tables in HIVE • Managed Tables • External Tables • Hive Data Types • Primitive Types • Complex Types • Partition • Joins in HIVE • HIVE UDF’s and UADF’s with Programs • Word Count Example HBASE:- • Introduction to HBASE • Basic Configurations of HBASE • Fundamentals of HBase • What is NoSQL? • HBase DataModel • Table and Row • Column Family and Column Qualifier • Cell and its Versioning • Categories of NoSQL Data Bases • Key-Value Database • Document Database • Column Family Database • SQL vs NOSQL • How HBASE is differ from RDBMS • HDFS vs HBase • Client side buffering or bulk uploads • HBase Designing Tables • HBase Operations • Get • Scan • Put • Delete MongoDB:-- • What is MongoDB? • Where to Use? • Configuration On Windows • Inserting the data into MongoDB? • Reading the MongoDB data. Cluster Setup:-- • Downloading and installing the Ubuntu12.x • Installing Java • Installing Hadoop • Creating Cluster • Increasing Decreasing the Cluster size • Monitoring the Cluster Health • Starting and Stopping the Nodes OOZIE • Introduction to OOZIE • Use of OOZIE • Where to use? Hadoop Ecosystem Overview Oozie HBase Pig Sqoop Casandra Chukwa Mahout Zoo Keeper Flume • Case Studies Discussions • Certification Guidance • Real Time Certification and • interview Questions and Answers • Resume Preparation • Providing all Materials nd Links • Real time Project Explanation and Practice

Demo has Scheduled Today BEST HADOOP ONLINE CERTIFICATION LEVEL TRAINING FROM HYDERABAD,INDIA FOR FREE DEMO contact us: Phone/WhatsApp: +91-(850) 012-2107 Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided Hadoop Key Concepts (we can modify the course content as per your requirement) HADOOP Using Cloudera Development & Admin Course Introduction:- • Big Data Introduction • Hadoop Introduction • What is Hadoop? Why Hadoop? • Hadoop History? • Different types of Components in Hadoop? • HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on… • What is the scope of Hadoop? Deep Drive in HDFS (for Storing the Data):- • Introduction of HDFS • HDFS Design • HDFS role in Hadoop • Features of HDFS • Daemons of Hadoop and its functionality • Name Node • Secondary Name Node • Job Tracker • Data Node • Task Tracker • Anatomy of File Wright • Anatomy of File Read • Network Topology • Nodes • Racks • Data Center • Parallel Copying using DistCp • Basic Configuration for HDFS • Data Organization • Blocks and • Replication • Rack Awareness • Heartbeat Signal • How to Store the Data into HDFS • How to Read the Data from HDFS • Accessing HDFS (Introduction of Basic UNIX commands) • CLI commands MapReduce using Java (Processing the Data):- • Introduction of MapReduce. • MapReduce Architecture • Data flow in MapReduce • Splits • Mapper • Portioning • Sort and shuffle • Combiner • Reducer • Understand Difference Between Block and InputSplit • Role of RecordReader • Basic Configuration of MapReduce • MapReduce life cycle • Driver Code • Mapper • and Reducer • How MapReduce Works • Writing and Executing the Basic MapReduce Program using Java • Submission & Initialization of MapReduce Job. • File Input/output Formats in MapReduce Jobs • Text Input Format • Key Value Input Format • Sequence File Input Format • NLine Input Format • Joins • Map-side Joins • Reducer-side Joins • Word Count Example • Partition MapReduce Program • Side Data Distribution • Distributed Cache (with Program) • Counters (with Program) • Types of Counters • Task Counters • Job Counters • User Defined Counters • Propagation of Counters • Job Scheduling PIG:- • Introduction to Apache PIG • Introduction to PIG Data Flow Engine • MapReduce vs PIG in detail • When should PIG used? • Data Types in PIG • Basic PIG programming • Modes of Execution in PIG • Local Mode and • MapReduce Mode • Execution Mechanisms • Grunt Shell • Script • Embedded • Operators/Transformations in PIG • PIG UDF’s with Program • Word Count Example in PIG • The difference between the MapReduce and PIG SQOOP:- • Introduction to SQOOP • Use of SQOOP • Connect to mySql database • SQOOP commands • Import • Export • Eval • Codegen and etc… • Joins in SQOOP • Export to MySQL HIVE:- • Introduction to HIVE • HIVE Meta Store • HIVE Architecture • Tables in HIVE • Managed Tables • External Tables • Hive Data Types • Primitive Types • Complex Types • Partition • Joins in HIVE • HIVE UDF’s and UADF’s with Programs • Word Count Example HBASE:- • Introduction to HBASE • Basic Configurations of HBASE • Fundamentals of HBase • What is NoSQL? • HBase DataModel • Table and Row • Column Family and Column Qualifier • Cell and its Versioning • Categories of NoSQL Data Bases • Key-Value Database • Document Database • Column Family Database • SQL vs NOSQL • How HBASE is differ from RDBMS • HDFS vs HBase • Client side buffering or bulk uploads • HBase Designing Tables • HBase Operations • Get • Scan • Put • Delete MongoDB:-- • What is MongoDB? • Where to Use? • Configuration On Windows • Inserting the data into MongoDB? • Reading the MongoDB data. Cluster Setup:-- • Downloading and installing the Ubuntu12.x • Installing Java • Installing Hadoop • Creating Cluster • Increasing Decreasing the Cluster size • Monitoring the Cluster Health • Starting and Stopping the Nodes OOZIE • Introduction to OOZIE • Use of OOZIE • Where to use? Hadoop Ecosystem Overview Oozie HBase Pig Sqoop Casandra Chukwa Mahout Zoo Keeper Flume • Case Studies Discussions • Certification Guidance • Real Time Certification and • interview Questions and Answers • Resume Preparation • Providing all Materials nd Links • Real time Project Explanation and Practice Phone/WhatsApp: +91-(850) 012-2107

HADOOP ONLINE TRAINING,CORPORATE TRAINING,JOB AND INTERVIEW SUPPORT BY CORPORATE PROFESSIONALS Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided Hadoop Concepts (we can modify the course content as per your requirement) HADOOP ADMIN AND DEVELOPMENT Introduction:- • Big Data Introduction • Hadoop Introduction • What is Hadoop? Why Hadoop? • Hadoop History? • Different types of Components in Hadoop? • HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on… • What is the scope of Hadoop? Deep Drive in HDFS (for Storing the Data):- • Introduction of HDFS • HDFS Design • HDFS role in Hadoop • Features of HDFS • Daemons of Hadoop and its functionality • Name Node • Secondary Name Node • Job Tracker • Data Node • Task Tracker • Anatomy of File Wright • Anatomy of File Read • Network Topology • Nodes • Racks • Data Center • Parallel Copying using DistCp • Basic Configuration for HDFS • Data Organization • Blocks and • Replication • Rack Awareness • Heartbeat Signal • How to Store the Data into HDFS • How to Read the Data from HDFS • Accessing HDFS (Introduction of Basic UNIX commands) • CLI commands MapReduce using Java (Processing the Data):- • Introduction of MapReduce. • MapReduce Architecture • Data flow in MapReduce • Splits • Mapper • Portioning • Sort and shuffle • Combiner • Reducer • Understand Difference Between Block and InputSplit • Role of RecordReader • Basic Configuration of MapReduce • MapReduce life cycle • Driver Code • Mapper • and Reducer • How MapReduce Works • Writing and Executing the Basic MapReduce Program using Java • Submission & Initialization of MapReduce Job. • File Input/output Formats in MapReduce Jobs • Text Input Format • Key Value Input Format • Sequence File Input Format • NLine Input Format • Joins • Map-side Joins • Reducer-side Joins • Word Count Example • Partition MapReduce Program • Side Data Distribution • Distributed Cache (with Program) • Counters (with Program) • Types of Counters • Task Counters • Job Counters • User Defined Counters • Propagation of Counters • Job Scheduling PIG:- • Introduction to Apache PIG • Introduction to PIG Data Flow Engine • MapReduce vs PIG in detail • When should PIG used? • Data Types in PIG • Basic PIG programming • Modes of Execution in PIG • Local Mode and • MapReduce Mode • Execution Mechanisms • Grunt Shell • Script • Embedded • Operators/Transformations in PIG • PIG UDF’s with Program • Word Count Example in PIG • The difference between the MapReduce and PIG SQOOP:- • Introduction to SQOOP • Use of SQOOP • Connect to mySql database • SQOOP commands • Import • Export • Eval • Codegen and etc… • Joins in SQOOP • Export to MySQL HIVE:- • Introduction to HIVE • HIVE Meta Store • HIVE Architecture • Tables in HIVE • Managed Tables • External Tables • Hive Data Types • Primitive Types • Complex Types • Partition • Joins in HIVE • HIVE UDF’s and UADF’s with Programs • Word Count Example HBASE:- • Introduction to HBASE • Basic Configurations of HBASE • Fundamentals of HBase • What is NoSQL? • HBase DataModel • Table and Row • Column Family and Column Qualifier • Cell and its Versioning • Categories of NoSQL Data Bases • Key-Value Database • Document Database • Column Family Database • SQL vs NOSQL • How HBASE is differ from RDBMS • HDFS vs HBase • Client side buffering or bulk uploads • HBase Designing Tables • HBase Operations • Get • Scan • Put • Delete MongoDB:-- • What is MongoDB? • Where to Use? • Configuration On Windows • Inserting the data into MongoDB? • Reading the MongoDB data. Cluster Setup:-- • Downloading and installing the Ubuntu12.x • Installing Java • Installing Hadoop • Creating Cluster • Increasing Decreasing the Cluster size • Monitoring the Cluster Health • Starting and Stopping the Nodes OOZIE • Introduction to OOZIE • Use of OOZIE • Where to use? Hadoop Ecosystem Overview Oozie HBase Pig Sqoop Casandra Chukwa Mahout Zoo Keeper Flume • Case Studies Discussions • Certification Guidance • Real Time Certification and • interview Questions and Answers • Resume Preparation • Providing all Materials nd Links • Real time Project Explanation and Practice

QA Testing Course Content: MANUAL TESTING SDLC 1. What are the different phases of SDLC? 2. How does the process of Software Development Start? 3. Project Initiation 4. Requirement Gathering and Analysis 5. What is Requirement document and what it contains? 6. What is use case document and what it contains? 7. What is Basic path and Alternate Path? 8. Role of Business Analyst 9. Example for explaining each phase 10. Role of technical specification team 11. What is Technical specification document? 12. What is System Design? 13. Role of Design team 14. What is design document? 15. Role of architecture team 16. System development 17. Role of development team 18. Deliverable of Development phase 19. System testing 20. Role of testers and types of testing 21. User acceptance testing 22. System deployment 23. System maintenance 24. Events in the maintenance phase like bug fixes 25. STLC 26. How are the phases of STLC carried out? 27. What is testing? 28. Role of testers 29. Why do we need to test? 30. Activities involved in the testing phase 31. What is test plan and test case document? 32. Steps of test case execution 33. What does test case document contain? 34. How to write test case document? 35. What is required to test any application? TEST CASES 1. What is test case? 2. What does test case document contain? 3. How to write test case document? 4. Different test case techniques TEST PLAN 1. What is Test Plan? 2. How to write test plan document? 3. What does the test plan document contain? 4. Who writes and approves the test plan document? 5. How manage the test case documents? 6. What is the pass/fail criterion? TYPES OF TESTING 1. Different Phases of testing 2. What is unit testing? 3. What is Minimum acceptance testing? 4. What is integration, system and system integration testing? 5. What is User acceptance testing? 6. What is Regression Testing? DEFECT ANALYSIS 1. What is a defect? 2. Various Defect tracking tools 3. How to use the defect tracking tools? 4. How to enter the details of defect in the defect tracking tool? 5. How to identify a defect? What is severity and priority? TRACEABILITY MATRIX 1. What is Traceability Matrix[TM]? 2. Who Prepares the TM document? 3. What is the reference for writing TM? 4. What is the use of TM? 5. What is present in the TM document? 6. Sample TM 7. Tools used for developing TM Various Teams and their Roles 1. Configuration Management Team 2. Role of configuration management team 3. What is Deployment? 4. Deployment Team 5. Role of Deployment team 6. Version Control 7. Various version tools and its usage 8. Difference between QC and QA 9. What is automation testing? 10. Why, what and when to automate? 11. Various tools used for automation testing MANAGEMENT TOOL QUALITY CENTER 1. Introduction to Quality Center 2. What is Quality Center ? 3. Why to use Quality Center 4. Version of Quality Center 5. Overview of quality Center user interface 6. Various tabs in Quality center 7. Requirement Module 8. Requirement Module Overview 9. Creating Requirement tree 10. Creating Parent & Child requirements 11. Understanding the Description tab 12. Understanding the History tab 13. Uploading attachments to requirement 14. A glance at various columns in requirement 15. Types of views in requirement module 16. Requirement grid view 17. Requirement coverage view 18. Test Plan Module 19. Creating folder structure 20. Create test cases 21. Requirement coverage 22. Test Lab Module 23. Overview of Test Lab 24. Detail of various tabs 25. Creating folders 26. Creating Test sets 27. Adding test cases 28. Different columns in Execution Grid 29. Execution Flow tab 30. Scheduling Test runs 31. Test Set Properties tab 32. Linked Defects tab 33. Running Tests manually 34. Running Tests automatically 35. Viewing Test results Quality Center Defects Overview of Defects 1. Creating defects after test execution 2. Adding defects in defect module 3. Creating defects during test execution 4. Linking Defects 5. How to close a defect 6. Closing defects after retest 7. Mailing the defects 8. Quality Center reports & graphs 9. Why Reports & Graphs? 10. How to create reports & graphs for Analysis? AUTOMATION TESTING: QUICK TEST PROFESSIONAL 1. Introduction to QTP 2. What is QTP 3. Prepare Before Automation 4. Application Under Test 5. First look at Add-Ins for QTP 6. Understanding the QTP User Interface Setting up preferences in QTP before recording. 1. Different versions of QTP(Text based) 2. Difference between QTP 9.0 and QTP 8.2. 3. Difference between QTP 9.2 and QTP 9.0 4. Difference between QTP 9.5 and QTP 9.2. • Record and run a script • Record a simple script • Save the script • Run the test script • Understand the result Introduction to Object Repository 1. What is Object Repository 2. Types of Object Repository 3. Object Repository Manager 4. Associating shared Object Repository with test 5. Shared Object Repository 6. Local Object Repository 7. Create a shared Object Repository 8. Add objects to shared Object Repository 9. Save an shared Object Repository 10. Modify the shared Object Repository 11. Comparing Local and Shared Object Repository Synchronization 1. What is Synchronization 2. Synchronization in QTP 3. Add Synchronization Steps for an Object Check Point 1. What is Check Point 2. Using Standard Check Point 3. Using Text Check Point 4. Using Access ability check point 5. Using XML Check Point Database checkpoint 1. What is database checkpoint 2. Writing SQL Query using Microsoft Query 3. Parameterize a database checkpoint 4. Output Values 5. What is Output value 6. Using Standard Output value 7. Using Text Output value 8. Using Database Output value 9. Using XML Output value Data Driven Test 1. What is Data Driven test 2. What is Parameterization http://trainingforu.blogspot.in/ Contact Person: Ashwini (M) 09620914455. Email: ashwini.hbst@gmail.com For More Details: Contact or Consult Our Office Once.

OBIEE Online Training Course Duration - 40hrs Sadguru Technologies-8179736190 Data warehousing overview Basics of Data Warehousing What is OLTP and OLAP? Difference between OLTP and OLAP Advantages of OLAP What is Data Marts and ODS? Dimensional Modeling Overview Introduction to Dimensional Modeling What are Facts and Dimensions? Star schema and Snowflake schema Introduction to Business Intelligence What is Business Intelligence Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server Server Architecture Repository Basics What is Meta data? Creating a Repository using BI Administration Tool Physical, Business Model and Mapping, and presentation layers Properties of repository objects Building Physical Layer of a Repository Objects of Physical Layer DSN for a data sources Build physical layer Building business Model mapping layer Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measuresOBIEE Online Training Course Duration - 40hrs Data warehousing overview Basics of Data Warehousing What is OLTP and OLAP? Difference between OLTP and OLAP Advantages of OLAP What is Data Marts and ODS? Dimensional Modeling Overview Introduction to Dimensional Modeling What are Facts and Dimensions? Star schema and Snowflake schema Introduction to Business Intelligence What is Business Intelligence Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server Server Architecture Repository Basics What is Meta data? Creating a Repository using BI Administration Tool Physical, Business Model and Mapping, and presentation layers Properties of repository objects Building Physical Layer of a Repository Objects of Physical Layer DSN for a data sources Build physical layer Building business Model mapping layer Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measures

FACULTY PROFILE: M.Sc & BSc in COMP.Sc.,SET qualified, GATE qualified, C-CAT(cdac.in) exam qualified, former guest lecturer of calcutta university affiliated college. Tuition offered for exam like:NET,SET,GATE,MCA,BCA,B.SC(CS),M.SC(CS),ssc,C-CAT(cdac.in) and other in computer science oriented exam and campus interview like BTECH(cs),MCA,BCA AND OTHER COMPUTER SCIENCE CAMPUS INTERVIEW. Tuition offered for the following field of computer science: C,C++,core java,Data Structure & algorithm, Automata Theory, Compiler Design,Database Management System, Operating System, Discrete math,Networking,Digital Logic,Computer organization & Architecture etc(according to the exam syllabus). I am experienced in when one find a coaching to having a proper guidance to crack an exam or interview, how they feel if they don't get it.EVERYBODY KNOW HOW CANDIDATE FEELING WHEN HE/SHE CAN'T UNDERSTAND THEIR SUBJECT AND NOT QUALIFYING EXAM,INTERVIEW WHICH THEY REQUIRED TO DO.AND OTHER FRIENDS AND RELATIVES WHEN GOT IT.THEREFORE STOP REGRETTING INSTEAD OF TAKE AN USEFUL STEP. The above all mentioned part OF COMP.SC. are really easy and interesting. But to student each parts are nightmare for college faculty'S teaching. And preparation of exam like net/set/gate AND CAMPUS INTERVIEW can't be done like our usual college and coaching classes, I want to show them how one can prepare oneself that no one can beat him/her for a single question from computer science. Often student skip the fundamental field comp.sc. like c,data structure, operating system,computer organization etc.Those are the part gateway of computer science and if one going through on these,then no one can't be beaten in campus interview for a single question.when someone got cleared his/her campus interview, others start making excuses how she/he got it, like he/she is from convent background, as if his/her question was easy than others, the interview topic was from this particular chapter which i had not read carefully etc. Stop thinking this kind of illogical concept.Those concept are no more useful.Better take some useful step.Learn properly C, DSA,OS and get cleared. I know accurately where student actually get confused and how to remove that. After long practices intermittently i found the secret of studying comp. sc and the secret ingredient is nothing but study comp. sc's book as you study your comics book. of course it is not easy as much as like i said, but definitely it's not impossible(I have done),and this habit one could be done between just 2-3 month. But our college and usual coaching classes faculty always make it impossible for hiding their poor knowledge. they act like a demigod and simply make comp sc impossible and make student suffer for their whole life. Today almost every school,college,institute teach little bit comp.sc(like c,java and certificate courses), then what are difference between a comp.sc student & a regular certificate candidate, well the difference is just a paper of certificate. I'll show them how to make difference beyond of certificate. I have many question set in each part of computer science.By practicing this student's skill definitely be improved,and you can feel that just after 4-5 classes. LISTEN VERY CAREFULLY CAMPUS INTERVIEW OR EXAM LIKE GATE/NET/SET/C-CAT,THOSE ARE IMPORTANT PART OF OUR LIFE. THESE WILL INFLUENCE OUR LIFE TILL DEATH, YES YOU TRY TO FEEL THAT.DON'T TAKE IT LIGHTLY,I'M NOT ASKING YOU TO GET TENSED, BUT THINK ABOUT IT SERIOUSLY. YOUR ONE VITAL STEP COULD CHANGE YOUR LIFE THAN OTHERS.AT LEAST 1 DAY EVERYONE SPEND THEIR TIME WITH NO USEFUL WORK IN A WEEK, THEN I SUGGEST YOU BETTER VISIT MY TUITION, TAKE A 4-5 HOUR LONG CLASS. YOU DON'T HAVE TO PAY ADVANCED FOR 1ST DAY 4-5 HOUR CLASS THOUGH THIS 4-5 HOUR IS NOT A DEMO CLASS,YOU WILL BE TAUGHT CORE PART.AFTER THAT IF YOU SATISFIED YOU CAN CONTINUE FOR ANOTHER DAY,OTHERWISE DON'T AND YOU DON'T NEED TO PAY FOR 1ST CLASS, AS MUCH AS SIMPLE. AGAIN YOUR ONE SUBTLE,SMALL BUT VERY IMPORTANT DECISION CAN CHANGE YOUR LIFE TILL DEATH. THINK AGAIN

We offered training on SAP WM (Ware house Management) by industry experienced trainer SAP WAREHOUSE MANAGEMENT TRAINING CURRICULUM Introduction to Warehouse Management Warehouse management overview in SAP R/3 Organization Data Warehouse Structure Warehouse Master Data WM Material master view Organization Data Define Warehouse structure Warehouse number Storage type Storage section Storage Bin Picking Area Storage unit Quant etc.. Master Data Material Master Storage bin Transfer Requirement Create Transfer requirement automatically Create Transfer requirement manually Create Transfer requirement for storage type Create Transfer requirement for material Posting change notice Create Posting change notice - PCN Transfer Order Number Range for TO Create TO w.r.t Transfer Requirement Create TO w.r.t Posting change notice no Create TO w.r.t Storage unit Create TO w.r.t Material document Create TO w.r.t Inbound delivery T.O. Creation In Background Confirm the Transfer Order Cancel the Transfer Order Print Transfer Order Inventory Management Activate Automatic T.O. Creation Set Up Auto T.O. Creation for TR's and PCN'S Allow Negative Stocks in Interim Storage Types Goods Movement (IM) Not Allowed for Storage Types Put away Strategies Next to empty bin Fixed Bin Open Storage Addition to existing bin Pallets Fixed bin strategy Picking Strategies Shelf life expired FIFO Stringent FIFO LIFO Warehouse Management Business Scenario's (MM) Goods Receipt processing with inbound delivery (with ASN) Goods receipt processing without inbound delivery Goods issue for internal consumption Replenishment Control for Storage Type Warehouse movement types Define reference movement types for WM Assign reference movement types to WM movement types Search Strategies Storage type search strategies Storage section search strategies Storage bin type search strategies Physical Inventory Create Physical inventory record Enter count results Clear the difference in WM Clear the difference in IM Batch Management in WM Condition Tables Access Sequence Strategy Types WM Batch Search Procedure Batch Status in WM Characteristics and class SLED In Batch in WM Manual And Automatic Batch Display In WM Integration WM with QM WM with PP WM with SD User Exists and Standard WM Reports Cross Docking Overview Home Why Us Online Training Register Privacy Policy Contact Us Please call arun on 9845382820 Techsys, Basaveshwaranagar, (near havanoor Circle) Bangalore - 79

SAP Warehouse Management Course Content Introduction to Warehouse Management • Organization Data • Master Data • Transactions • Reports Organization Data Define Warehouse Structure • Warehouse Number • Storage Type • Storage Section • Storage Unit Master Data • Material Master • Storage Bin Transfer Requirement • Create Transfer Requirement Automatically • Create Transfer Requirement Manually • Create Transfer Requirement for Storage Type • Create Transfer Requirement for Material Posting change notice • Create Posting change notice Transfer Order • Number Range for TO • Create TO w.r.t Transfer Requirement • Create TO w.r.t Posting Change Notice No • Create TO w.r.t Storage Unit Number • Create TO w.r.t Material Document • Create TO w.r.t Inbound/Out Bound Delivery • Confirm the Transfer Order • Cancel the Transfer Order Put away Strategies • Next to Empty Bin • Addition to Existing Bin • Bulk Storage • Fixed Bin Strategy • Storage Unit Type Picking Strategies • Shelf Life Expired • FIFO • LIFO • Stringent Picking Business Scenario’s • Goods Receipt Processing with Inbound Delivery • Goods Receipt Processing with out Inbound Delivery • Goods Issue with out Bound Delivery • Goods Issue for Internal Consumption • Stock Transfer from Warehouse Store to Non-Warehouse Store • Stock Transfer from Warehouse to Warehouse Store • Stock Transfer from Non Warehouse-to-Warehouse Store • Stock Transfer from Bin to Bin • Stock Transfer from Stock Type to Stock Type • Multiple Picking Process for TR's/Outbound Deliveries • Two Step Picking and Wave Picks Storage unit management • Define Storage Types with Storage Unit Management • Put away and Picking Strategies with Storage Unit Management • Create Transfer Order with Storage Unit Number Physical Inventory • Create Physical Inventory Record • Enter Count Results • Clear the Difference in WM • Clear the Difference in IM Warehouse movement types • Define Reference Movement Types for WM • Assign Reference Movement Types to WM Movement Types • Define WM Movement Types Search Strategies • Storage Type Search Strategies • Storage Section Search Strategies • Storage Bin Type Search Strategies RFID Overview All Training reference Materials would be provided as a part of the course. SAP ECC 6.0 EHP 5 Server will also be configured as part of this training.(Hands on)

Informatica Trainers required in elegant it services good salary based on quality training After successfully completing this course, students should be able to: • Use PowerCenter 9.x Designer to build mappings that move data from sources to targets • Use PowerCenter 9.x Workflow Manager to build and run a workflow that runs a session based on a mapping • Design mappings and workflows based on business needs • Perform basic troubleshooting of PowerCenter mappings and transformations • Use Informatica Support options to resolve questions and problems about Informatica PowerCenter 9 • Introducing the need of ETL • Overview of Informatica Architecture • Client tools and Server tools and Create,Manage and Edit Objects • Powercenter Designer • Importing Source file/Target File (Fixed width, Delimted) and File Properties • Build mapping to load data from flat files • Powercenter Workflow Manager and Monitor • Session Properties • Creation of Workflow Task (Session) and use it Workflow • Lab – Importing File Definition Using Designer • Lab Session • Transformation Overview • Transformation data types • Source Qualifier • Source Qualifier Transformation • Source Qualifier Properties • ASource Qualifier Joins • Source Pipelines • Using Sorted Ports • Lab Session Expression Transformation • Expression Editor • Ports (Input, Output and Variable) • Transformation Function Overview • Lab Session Filter Transformation • Filter Properties • Difference between Source Qualifier Filter and Filter Transformation • Lab Session Router Transformation • Overview • Working with Groups • Working with Ports • Connecting Router Transformations in a Mapping • Creating a Router Transformation • Difference between Router and Filter • Lab Session Sorter and Aggregator • Sorter, Aggregator and Self Join • Sorter Transformation • Aggregator Transformation • Active and Passive Transformations • Data Concatenation • Self-Join • Lab Session Rank Transformation • Overview • Ports in a Rank Transformation • Defining Groups • Creating a Rank Transformation • Lab Session Joiner Transformation • Joins, Features and Techniques I • Joiner Transformation • Shortcuts • Lab Session Union Transformation • Working with Groups and Ports • Creating a Union Transformation • Using a Union Transformation in a Mapping • Debugger & Debugging Mappings • Lab Session Lookups and Reusable Transformations • Lookup Transformation • Reusable Transformations • Lookup Caching • Lab Session Sequence generator Transformation • Overview • Common Uses • Sequence Generator Ports • Transformation Properties • Creating a Sequence Generator Transformation • Lab Session Load Strategies • Truncate and Load • Insert Only • Update Only • Update else Insert/Insert Else Update • Lab Session Update Strategy and Overrides • Update Strategy Transformation • Expression Default Values • Source Qualifier Override • Target Override • Session Task Mapping Overrides • Lab Session Working with SCD Type1 and Type2 • Introducing SCDs, type 1, 2 & 3 • Implementing type 1 • Implementing type 2 • Lab Session Dynamic Lookup and Error Logging • Dynamic Lookup • Error Logging • Unconnected Lookup • Unconnected Lookup Transformation • Lab Session Working with Sessions • Editing a Session • Using Pre- and Post-Session SQL Commands • Using Pre- and Post-Session OS Commands • Validating a Session • Stopping and Aborting a Session • Working with Session Parameters • Mapping Parameters and Variables in Sessions • Assigning Parameter and Variable Values in a Session • Lab Session Workflow Variables and Tasks • Link Conditions • Workflow Variables • Assignment Task • Decision Task • Email Task • Event Raise Task • Event Wait Task • Command Task • Reusable Tasks • Reusable Session Configuration • Lab Session Overview of Informatica Basic Administration, Roles & Responsibilities Covers the Performance tuning Techniques, new transformations..and migration of objects from one Folder/Environment to another environment Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly O

INFRMATICA organization oriented training in elegant it services • Use PowerCenter 9.x Designer to build mappings that move data from sources to targets • Use PowerCenter 9.x Workflow Manager to build and run a workflow that runs a session based on a mapping • Design mappings and workflows based on business needs • Perform basic troubleshooting of PowerCenter mappings and transformations • Use Informatica Support options to resolve questions and problems about Informatica PowerCenter 9 • Introducing the need of ETL • Overview of Informatica Architecture • Client tools and Server tools and Create,Manage and Edit Objects • Powercenter Designer • Importing Source file/Target File (Fixed width, Delimted) and File Properties • Build mapping to load data from flat files • Powercenter Workflow Manager and Monitor • Session Properties • Creation of Workflow Task (Session) and use it Workflow • Lab – Importing File Definition Using Designer • Lab Session • Transformation Overview • Transformation data types • Source Qualifier • Source Qualifier Transformation • Source Qualifier Properties • ASource Qualifier Joins • Source Pipelines • Using Sorted Ports • Lab Session Expression Transformation • Expression Editor • Ports (Input, Output and Variable) • Transformation Function Overview • Lab Session Filter Transformation • Filter Properties • Difference between Source Qualifier Filter and Filter Transformation • Lab Session Router Transformation • Overview • Working with Groups • Working with Ports • Connecting Router Transformations in a Mapping • Creating a Router Transformation • Difference between Router and Filter • Lab Session Sorter and Aggregator • Sorter, Aggregator and Self Join • Sorter Transformation • Aggregator Transformation • Active and Passive Transformations • Data Concatenation • Self-Join • Lab Session Rank Transformation • Overview • Ports in a Rank Transformation • Defining Groups • Creating a Rank Transformation • Lab Session Joiner Transformation • Joins, Features and Techniques I • Joiner Transformation • Shortcuts • Lab Session Union Transformation • Working with Groups and Ports • Creating a Union Transformation • Using a Union Transformation in a Mapping • Debugger & Debugging Mappings • Lab Session Lookups and Reusable Transformations • Lookup Transformation • Reusable Transformations • Lookup Caching • Lab Session Sequence generator Transformation • Overview • Common Uses • Sequence Generator Ports • Transformation Properties • Creating a Sequence Generator Transformation • Lab Session Load Strategies • Truncate and Load • Insert Only • Update Only • Update else Insert/Insert Else Update • Lab Session Update Strategy and Overrides • Update Strategy Transformation • Expression Default Values • Source Qualifier Override • Target Override • Session Task Mapping Overrides • Lab Session Working with SCD Type1 and Type2 • Introducing SCDs, type 1, 2 & 3 • Implementing type 1 • Implementing type 2 • Lab Session Dynamic Lookup and Error Logging • Dynamic Lookup • Error Logging Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers, Bangalore - .Ph: -/87

SAP WM COURSE CONTENT Introduction to Warehouse Management •Warehouse management overview in SAP R/3 •Organization Data •Warehouse Structure Organization Data / Define Warehouse Organization structure •Warehouse number •Storage type •Storage section •Storage Bin •Storage Bin Structure •Storage Bin Types •Picking Area •Storage unit •Quant etc... Master Data •Material Master Transfer Requirement •Number Range for TR •Create Transfer requirement Manually •Create Transfer requirement Automatically •Settings for Automatic TR Creation •Convert TR to TO Transfer Order •Number Range for TO •Create Transfer Order Manually •Create TO w.r.t Transfer Requirement •Confirm the Transfer Order •Cancel the Transfer Order •Delete TO •Block and Unblock Storage Bins, Quants, Storage Types •Print TO •Automatic TO Creation and Confirmation •Business Examples Put away Strategies •Next to empty bin •Addition to existing bin •Open Storage •Fixed bin strategy •Business examples Warehouse Management Business Scenario's (MM) •MM Flow with Interface with WM •Material Documents Processing in WM •GR and GI with WM •Transfer Posting in WM oPlant to Plant oSloc to Sloc oStock TO Stock oSchema Group Vendor •STO – Stock Transport Order using WM (MM-SD-WM Interface) •Business examples Physical Inventory Processes in WM •Create Physical inventory record •Enter count results •Clear the difference in WM •Clear the difference in IM Hazardous Material Management •Introduction to Hazardows Materials •Hazardous Material Record •Hazardous Material Functionality •Business Examples-Hazardous Material Management RFID •Introduction to RFID •Types of RFID Tags •Current Uses of RFID •Business Examples- RFID Integration WM with SD •Technical Knowledge •Reports. •IDOC. •Tables. •Additional Topics

SAS Clinical Research Trainers required for elegant it services good salary based on training quality 1. History of SAS 2. SAS comes in ERP sector or not? Why? 3. Role of Statistical Analysis in Clinical Research Study and Banking analysis 4. SAS role in Clinical Research Study and Banking analysis 5. Data modeling and Data mining concepts 6. Project management in Clinical Research Study analysis and Banking analysis 7. What is Clinical research Study? 8. What is Protocol and role of Protocol in Clinical Research Study? 9. What is randomization and non randomization? Which is playing 10. Main role in Clinical research study? 11.What is SOP (Standard operating Procedure)? 11. What is DBMS? 12. Role of DBMS team in Clinical Research Study 13. What is CDM (Clinical data management)? 14. Importance of CDM systems for data loading 15. What is SAP (Statistical Analysis Plan)? 16. Role of SAP in Clinical Research Study 17. SAS Work Flow in Clinical Research Study 18. Relation between SAS and DBMS 19. Interaction between SAS with CDMs for data access 20. Various report generation in Clinical Research Study 21. Role of SAS in Credit Analysis and Different Banking Channels 22. When will go any Industry for Data modeling and Data mining 23. Role of SAS in Data modeling and Data mining GETTING STARTED WITH SAS SYSTEMS: 1. Basic operating system commands, operating system file structures 2. Managing windows in SAS window environment 3. How to run SAS application in different modes and in different environment like Windows, Unix and Mainframes. 4. Use of different kind of SAS products and how to use in SAS application. 5. Difference between the SAS products. 6. Why using the SAS in different sectors 7. How to use the Data Step to read and manipulate complex forms of data 8. Write Data and Proc Steps 9. Data step compile and execution 10. To run SAS application on different modes 11. Reading internal raw data into SAS 12. Read any type of external raw data into SAS 13. Reading raw data SAS environment into DATASET using Input statement & advance INFILE Statement options 14. Working with Data Storage in SAS libraries creation for user defined libraries and multi-engine architecture 15. Using a single libref to reference some or all SAS libraries reading and printing mixed records formats 16. Reading packed and zoned decimal data Working with EBCDIC and ASCII data 17. Reading data from dataset to another dataset 18. To manage the SAS window environment use with Global options 19. Reducing memory requirements with BUFFNO and BUFSIZE working with SAS dataset options 20. To manage existing data with controlling statements and expressions 21. Creating summary information, SAS functions, transforming data 22. Changing variable types using the PUT and INPUT functions Summarizing Data Files 23. Generation Data Sets to create historical information SAS 24. To export data from datasets to delimiter files using with dataset block 25. Understand error messages in the SAS log and debug your program 26. Use with error handling concepts Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers,

SOA service based training in elegant it services Importance of SOA Evolution of Oracle SOA Why Oracle SOA? Components in Oracle SOA Introduction to XML Concepts Introduction to XML Purpose of the XML Why XML? XML Guidelines Well formed XML and Valid XML Introduction to XSD Importance of XSD Defining an XSD Simple Type and Complex Type Importance of Namespace XSD Validations Introduction to XSL Transformation Introduction to WSDL Introduction to Web services Introduction to SOAP Message Oracle SOA Installations Installing Database Running RCU Installing Weblogic Server Installing SOA Suite Creating a Domain Installing JDeveloper Applying SOA Extension in JDeveloper Introduction to JDevloper Creating Application Creating Project Introduction to SCA Architecture Creating IDE/ Application Connection Creating Application Server Connection Connection to SQL Worksheet Introduction to Application Navigator Introduction to Component Palette Introduction to Resource Palette Introduction to Structure Window Introduction to Mediator Component Why Mediator? Creating a Mediator Target Type Echo/Service/Event Understanding Importance of Source and Target in Transformation Creating a Transformation Request/Reply Applying Filtration Understanding the Importance of various Templates Invoking External Services Introduction to Expression Builder Introduction to MDS What is MDS? Why MDS? Types of MDS Setup/Configuring MDS Ways to deploy the Artifact’s to MDS Creating MDS Connection Deploying Artifact’s to MDS through JDevloper Accessing MDS Objects Introduction to BPEL Component What is BPEL? Performing Orchestration in Oracle SOA Creating a BPEL Process Introduction to Default Variables Understanding the main Scope Introduction to Partner Links Creating Partner Links Understanding the Importance of various Templates Introduction to BPEL Constructs Introduction to Oracle Extensions Introduction to SOA Components Introduction to BPEL Services Difference between Scope/Sequence Difference between Local Variables/Global Variables Difference between Receive and Pick Activity Introduction to Database Adapter Introduction to Database Adapter Creating Data sources Creating a Connection Pool Elegant IT Services, #nd Floor, Aswath Nagar,Varthur main road, Opp Safal Fresh,Near Railway Fly Over Maratha halli,Bangalore - .Ph:-/87

OSB industry level training in elegant it services Importance of SOA Evolution of Oracle SOA Why Oracle SOA? Components in Oracle SOA Introduction to XML Concepts Introduction to XML Purpose of the XML Why XML? XML Guidelines Well formed XML and Valid XML Introduction to XSD Importance of XSD Defining an XSD Simple Type and Complex Type Importance of Namespace XSD Validations Introduction to XSL Transformation Introduction to WSDL Introduction to Web services Introduction to SOAP Message Oracle SOA Installations Installing Database Running RCU Installing Weblogic Server Installing SOA Suite Creating a Domain Installing JDeveloper Applying SOA Extension in JDeveloper Introduction to JDevloper Creating Application Creating Project Introduction to SCA Architecture Creating IDE/ Application Connection Creating Application Server Connection Connection to SQL Worksheet Introduction to Application Navigator Introduction to Component Palette Introduction to Resource Palette Introduction to Structure Window Introduction to Mediator Component Why Mediator? Creating a Mediator Target Type Echo/Service/Event Understanding Importance of Source and Target in Transformation Creating a Transformation Request/Reply Applying Filtration Understanding the Importance of various Templates Invoking External Services Introduction to Expression Builder Introduction to MDS What is MDS? Why MDS? Types of MDS Setup/Configuring MDS Ways to deploy the Artifact’s to MDS Creating MDS Connection Deploying Artifact’s to MDS through JDevloper Accessing MDS Objects Introduction to BPEL Component What is BPEL? Performing Orchestration in Oracle SOA Creating a BPEL Process Introduction to Default Variables Understanding the main Scope Introduction to Partner Links Creating Partner Links Understanding the Importance of various Templates Introduction to BPEL Constructs Introduction to Oracle Extensions Introduction to SOA Components Introduction to BPEL Services Difference between Scope/Sequence Difference between Local Variables/Global Variables Difference between Receive and Pick Activity Introduction to Database Adapter Introduction to Database Adapter Creating Data sources Creating a Connection Pool Introduction to SOA Introduction to ESB Introduction to Oracle Service Bus Why Oracle Service Bus? When should we go for OSB? Oracle Service Bus Functional Features Adaptive Messaging Service Security Service Virtualization Service Management Configuration Framework OSB and the Service Life Cycle OSB Architecture Introduction to Proxy Service Introduction to Business Service Introduction to Binding Layer Introduction to Transport Layer OSB Message Flow Definitions Oracle Service Bus Installations Installing DB Running RCU Installing Weblogic Server Installing SOA Suite Installing OSB Suite Applying OEPE Creating a Domain Installing JDeveloper Applying SOA Extension in JDeveloper Opening Eclipse Introducing OSB Services Understanding/Creating a new OSB Configuration in Eclipse OEPE Creating a new OSB Project in Eclipse OEPE Creating the folder structure to place the artifacts Creating a business service based on the WSDL Generating a simple pass-through Proxy Service based on the Business Service Creating a connection/server to deploy the OSB services Testing the proxy service through the OSB console Exploring OSB Artifacts in Eclipse OEPE Importing OSB Project Exporting OSB Project Moving artifacts in Eclipse OEPE by drag-and-drop Copying artifacts in Eclipse OEPE from one folder to another Moving artifacts in Eclipse OEPE inside the same OSB project Copying artifacts from one project into another in Eclipse OEPE Debugging services through Eclipse OEPE OSB Message Flow Modeling Operational Pipelines Branch Nodes Route Nodes Pipeline Pairs Operational Branching Service Callouts OSB Communication Actions OSB Flow Control Actions OSB Message Processing Actions OSB Reporting Actions OSB Message Processing Elegant IT Services, #nd Floor, Aswath Nagar,Varthur main road, Opp Safal Fresh,Near Railway Fly Over Maratha halli,Bangalore - .Ph:-/87

SAS Clinical research organization oriented training in elegant it services in marathahalli. 1. History of SAS 2. SAS comes in ERP sector or not? Why? 3. Role of Statistical Analysis in Clinical Research Study and Banking analysis 4. SAS role in Clinical Research Study and Banking analysis 5. Data modeling and Data mining concepts 6. Project management in Clinical Research Study analysis and Banking analysis 7. What is Clinical research Study? 8. What is Protocol and role of Protocol in Clinical Research Study? 9. What is randomization and non randomization? Which is playing 10. Main role in Clinical research study? 11.What is SOP (Standard operating Procedure)? 11. What is DBMS? 12. Role of DBMS team in Clinical Research Study 13. What is CDM (Clinical data management)? 14. Importance of CDM systems for data loading 15. What is SAP (Statistical Analysis Plan)? 16. Role of SAP in Clinical Research Study 17. SAS Work Flow in Clinical Research Study 18. Relation between SAS and DBMS 19. Interaction between SAS with CDMs for data access 20. Various report generation in Clinical Research Study 21. Role of SAS in Credit Analysis and Different Banking Channels 22. When will go any Industry for Data modeling and Data mining 23. Role of SAS in Data modeling and Data mining GETTING STARTED WITH SAS SYSTEMS: 1. Basic operating system commands, operating system file structures 2. Managing windows in SAS window environment 3. How to run SAS application in different modes and in different environment like Windows, Unix and Mainframes. 4. Use of different kind of SAS products and how to use in SAS application. 5. Difference between the SAS products. 6. Why using the SAS in different sectors 7. How to use the Data Step to read and manipulate complex forms of data 8. Write Data and Proc Steps 9. Data step compile and execution 10. To run SAS application on different modes 11. Reading internal raw data into SAS 12. Read any type of external raw data into SAS 13. Reading raw data SAS environment into DATASET using Input statement & advance INFILE Statement options 14. Working with Data Storage in SAS libraries creation for user defined libraries and multi-engine architecture 15. Using a single libref to reference some or all SAS libraries reading and printing mixed records formats 16. Reading packed and zoned decimal data Working with EBCDIC and ASCII data 17. Reading data from dataset to another dataset 18. To manage the SAS window environment use with Global options 19. Reducing memory requirements with BUFFNO and BUFSIZE working with SAS dataset options 20. To manage existing data with controlling statements and expressions 21. Creating summary information, SAS functions, transforming data 22. Changing variable types using the PUT and INPUT functions Summarizing Data Files 23. Generation Data Sets to create historical information SAS 24. To export data from datasets to delimiter files using with dataset block 25. Understand error messages in the SAS log and debug your program 26. Use with error handling concepts Thanks&Regards Elegant IT Services, #nd Floor, Aswath Nagar,Varthur main road, Opp Safal Fresh,Near Railway Fly Over Maratha halli,Bangalore

Softgen Infotech located in BTM Layout, Bangalore is a leading training institute providing real-time and placement oriented Informatica Training Courses in bangalore. Our Informatica training course includes basic to advanced levels. we have a team of certified trainers who are working professionals with hands on real time Informatica projects knowledge which will provide you an edge over other training institutes. Our Informatica training centre is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide certification training programs in Informatica Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our team of experts at Softgen Infotech Training Institute, Bangalore have designed our Informatica Training course content and syllabus based on students requirements to achieve everyone's career goal. Our Informatica Training course fee is economical and tailor-made based on training requirement. We Provide regular training classes(day time classes), weekend training classes, and fast track training classes for Informatica Training in our centres located across bangalore. We also provide Online Training Classes for Informatica Training Course. Contact us today to schedule a free demo and complete course details on Informatica Training Course. What is Informatica Training ? Informatica Training Objectives Completeness- data missing or unusable?Confirmity- data stored in a non standard format?Consistency, Accuracy, Duplicates, Integrity.Leverage Informatica s expertise in metadata reporting planning and deployment.Understand the optimal Informatica architecture for your metadata needs.Preview custom metadata reports and dashboards based on your project objectives and Informaticas best practice.Metadata Reporting Enablement Strategy.Metadata reporting standards.Demonstration of Informaticas out-of-the-box and customized reports and dashboards based on your metadata requirements. Training Prerequesites Basics of data ware housingGood to have an idea about sql and pl/sqlGood to have a knowledge on Oracle database and its functionality Course Outline INTRODUCTION TO DATA WAREHOUSING Data warehouse concept Differences between Online Transaction Processing and data warehouse Types of Data Warehouse Data warehouse Architecture Difference between Data warehouse & Data mart Data Warehouse Approaches Data Warehouse Components Logical & physical Design* Operational data sources(ODS) OLAP and its types: ROLAP, MOLAP, HOLAP, DOLAP TOOL KNOWLEDGE Informatica PowerCenter Product Overview Power Center Domain Administration Console PowerCenter Repository PowerCenter Client Repository Service INTEGRATION SERVICE WEB SERVICES HUB MODELLING FOR DATA WAREHOUSE Defining Fact, Dimension, Attributes, Hierarchies, Grain and Granularity Grain and Granularity of Data Fact Table Dimension tables and types* Data Warehouse Schemas*: Star schema and Star Query, star flake schema, snow flake schema and Galaxy Schema REPOSITORY MANAGER Adding a Repository to the Navigator Configuring a Domain Connection Connecting to a Repository Viewing Object Dependencies Validating Multiple Objects Comparing Repository Objects Truncating Workflow and Session Log Entries Managing User Connections and Locks Managing Users and Groups Working with Folders POWERCENTER DESIGNER Source Analyzer Working with Relational Sources Working with Flat Files Target Designer Mappings Transformations Working with Ports Using Default Values for Ports User-Defined Default Values Tracing Levels Basic First Mapping Expression Transformation Filter Transformation Router Transformation Union Transformation Sorter Transformation Rank Transformation Aggregator Transformation Joiner Transformation Source Qualifier Lookup Transformation Lookup Types Lookup Transformation Components Connected Lookup Transformation Unconnected Lookup Transformation Lookup Cache Types: Dynamic, Static, Persistent, Shared Update Strategy Dynamic Lookup Cache Use Lookup Query Lookup and Update Strategy Examples Stored Procedure Transformation Connected Stored Procedure Transformation Unconnected Stored Procedure Transformation Sequence Generator Transformation Mapplets: Mapplet Input and Mapplet Output Transformations Normalizer Transformation XML Sources Import and usage Mapping Wizards Getting Started Slowly Changing Dimensions Mapping Parameters and Variables Parameter File Indirect Flat File Loading WORKFLOW MANAGER Working with Workflows Assigning an Integration Service Working with Links Workflow Variables Session Parameters Working with Tasks Session Task Email Task Command Task Working with Event Tasks Timer Task Decision Task Control Task Assignment Task Schedulers Worklets Partitioning Partitioning Attributes Partitioning Types Session Properties Workflow Properties ADVANCED TOPICS Push down Optimization Technique Unit Testing Version Control Real time Scenario on Dynamic Lookup Cache Real time Scenario on Unconnected Stored procedure and lookup transformation Constraint Based Load Ordering Target Load Plan Order. Informatica Training Course Details Duration:45 Hours Version:latest Version Regular: 1 Hour per day Fast Track: 2 - 3 Hours per day: 10 days Weekdays:Monday - Friday Weekend:Saturday and Sunday Online Training:Available Class Room Training: Available Course Fee: Talk to our Customer Support Mode of Payment:Talk to our Customer Support

Ikyaglobaledu is the best in providing SAS Training in hyderabad with 100% placement assistance. We provide SAS Training with covering all concepts and our syllabus is here Program Coverage: This foundation course focuses on the following key areas: reading raw data files and SAS data sets and writing the results to SAS data sets; subsetting data; combining multiple SAS files; creating SAS variables and recoding data values; and creating listing and summary reports. Getting Started with the SAS System: •Accessing the SAS System •Navigating among the SAS programming windows •Understanding the difference between batch mode and interactive mode •Opening and submitting a program in the Program Editor window •Checking the SAS log for program errors •Examining your program's output •Understanding data sets, variables, and observations •Understanding DATA and PROC steps •Diagnosing and correcting programming errors •Explaining SAS syntax and SAS naming conventions Getting Familiar with SAS Data Sets: •Explain the concept of a SAS data library •Differentiate between a permanent library and a temporary library •Investigate a SAS data library using the CONTENTS procedure Producing List Reports: •Generate simple list reports using the PRINT procedure •Display selected columns and rows in a list report •Display a list report with column totals •Sort observations in a SAS data set •Control page breaks for subgroups •Identify observations using the ID statement Enhancing Output: •Customizing report appearance •Formatting data values •Creating HTML reports Creating SAS Data Sets: •Using column input and formatted input •Examining data errors •Assigning variable attributes Programming with the DATA Step: •Reading SAS data sets and creating variables •Executing statements conditionally using IF-THEN logic •Controlling the length of character variables explicitly with the LENGTH statement •Selecting rows to include in a SAS data set •Using SAS date constants Combining SAS Data Sets: •Using the SET statement to concatenate two or more SAS data sets •Using the RENAME= data set option to change the names of variables •Using the SET and BY statements to interleave two or more SAS Data Sets Producing Summary Reports: •Creating one-way and two-way frequency tables using the FREQ procedure •Generate simple descriptive statistics using the MEANS procedure •Using the REPORT procedure to create a listing report •Using the RBREAK statement to produce a grand total Introduction to Graphics (Optional): •Producing bar and pie charts •Enhancing output with titles, footnotes, color, and fonts •Producing plots •Controlling appearance of the axes For more information about the SAS Course please call us @

Type Tutoring INSTALLING AND SETTING UP THE WAREHOUSE BUILDER ENVIRONMENT What Is Oracle Warehouse Builder? Basic Process Flow of Design and Deployment Oracle Warehouse Builder Licensing and Connectivity Options Installing Oracle Warehouse Builder 11.2 OWBSYS Schema Using OWB 11.2 with Database 10g R2 Using the Repository Assistant to Manage Workspaces Supported operating systems (OS), sources, targets, and optional components GETTING STARTED WITH WAREHOUSE BUILDER Logging In to OWB Design Center Overview of the Design Center OWB Projects Overview of Objects within a Project Overview of Objects within an Oracle Module Organizing Metadata Using Foldering Locations Navigator and Globals Navigator panels Setting Projects Preferences: Recent Logons UNDERSTANDING THE WAREHOUSE BUILDER ARCHITECTURE Warehouse Builder Development Cycle Overview of the Architecture for Design, Deployment, Execution Overview of Configurations, Control Centers, and Locations Creating Target Schemas Registering DB User as an OWB User Roles and Privileges of Warehouse Builder Users Registering an Oracle Workflow User DEFINING SOURCE METADATA Data warehouse implementation: Typical steps Difference Between Obtaining Relational and Flat File Source Metadata Creating Flat File Module Sampling Simple Delimited File Sampling Multi-record Flat File Creating an Oracle Module Selecting the Tables for Import DEFINING ETL MAPPINGS FOR STAGING DATA Purpose of a Staging Area Define OWB Mappings Mapping Editor Interface: Grouping, Ungrouping, and Spotlighting Creating External Tables Create and Bind process Levels of Synchronizing Changes Using the Automapper in the Mapping Editor Set loading type and target load ordering USING THE DATA TRANSFORMATION OPERATORS Component Palette Using a Joiner Lookup Operator: Handling Multiple Match Rows Using the Subquery Filter Operator Using the Set, Sequence, and Splitter Operators Pivot and Unpivot Operators Using the Aggreagator, Constant, Transformation, and Pre/Post Mapping Operators Deploying and Executing in Projects Navigator Panel CLEANSING AND MATCH-MERGING NAME AND ADDRESS DATA Integrating Data Quality into ETL Name and Address Data Cleansing Name and Address Server Name and Address Software Providers Settings in the Name and Address Operator Reviewing a Name and Address Mapping Consolidating Data Using the Match Merge Operator Using the Match Merge Operator in a Mapping USING PROCESS FLOWS Process Flow Concepts Creating a Process Flow Module, a Process Flow Package and a Process Flow Types of Activities: Fork, And, Mapping, End Activity Creating Transitions Between Activities Some More Activities: Manual, SQLPLUS, Email Generating the Process Flow Package DEPLOYING AND REPORTING ON ETL JOBS Logical Versus Physical Implementation Setting Object Configuration Deployment Concepts Invoking the Control Center Manager Deploy Options and Preferences Repository Browser Starting OWB Browser Listener and the Repository Browser Browsing Design Center and Control Center Reports USING THE MAPPING DEBUGGER Overview of the Mapping Debugger Initializing a Mapping Debugging Session Preparing the testing environment and test data Setting breakpoints and watch points Evaluating the flow of data to detect mapping errors ENHANCING ETL PERFORMANCE Performance Tuning at Various Levels Performance-Related Parameters in ETL Design Configuring Mappings for Operating Modes, DML Error Logging, Commit Control, and Default Audit Levels Enabling Partition Exchange Loading (PEL) for Targets Performance-Related Parameters in Schema Design Configuring Indexes, Partitions, Constraints Enabling Parallelism and Parallel DML Setting Tablespace Properties and Gathering Schema Statistics MANAGING BACKUPS, DEVELOPMENT CHANGES, AND SECURITY Overview of Metadata Loader Utilities (MDL) Managing Metadata Changes by Using Snapshots Using Change Manager Version Management of Design Objects Graphical UI for Security Management Object-Level Security Setting Security Parameters INTEGRATING WITH ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION (OBI EE) Business Justification: Tools Integration Integrating with OBI EE and OBI SE Transferring BI Metadata to OBI EE Server Setting Up the UDML File Location Deriving the BI Metadata (OBI EE) Deploying the BI Module Converting the UDML File for OBI EE Oracle BI Admin and Answers Tool APPENDIX B: CREATING EXPERTS Harnessing OWB Power and Complexity for New Users OWB "Experts": Directed Guidance and Knowledge Management Creating an Expert Starting an Expert Creating Your Own Custom Dialog Scenario: ROLAP to MOLAP in Five Easy Steps Scenario: Expert for Creating External Table APPENDIX C: USING DIAGNOSIS AND DEBUGGING TECHNIQUES Collecting Information Before Contacting Oracle Support Sequence Used by Oracle Support Representatives to Process Calls Activating Debugging and Logging for Full Java Debug Trace Activating Tracing Using the Service_Doctor.sql Script Troubleshooting and Diagnosing Errors in Control Center Agent (CCA) Run-Time Views and Utilities Online Warehouse Builder Resources

Type Tutoring The Best OWB Online Training Institute From Hyderabad, India Course Content: INSTALLING AND SETTING UP THE WAREHOUSE BUILDER ENVIRONMENT What Is Oracle Warehouse Builder? Basic Process Flow of Design and Deployment Oracle Warehouse Builder Licensing and Connectivity Options Installing Oracle Warehouse Builder 11.2 OWBSYS Schema Using OWB 11.2 with Database 10g R2 Using the Repository Assistant to Manage Workspaces Supported operating systems (OS), sources, targets, and optional components GETTING STARTED WITH WAREHOUSE BUILDER Logging In to OWB Design Center Overview of the Design Center OWB Projects Overview of Objects within a Project Overview of Objects within an Oracle Module Organizing Metadata Using Foldering Locations Navigator and Globals Navigator panels Setting Projects Preferences: Recent Logons UNDERSTANDING THE WAREHOUSE BUILDER ARCHITECTURE Warehouse Builder Development Cycle Overview of the Architecture for Design, Deployment, Execution Overview of Configurations, Control Centers, and Locations Creating Target Schemas Registering DB User as an OWB User Roles and Privileges of Warehouse Builder Users Registering an Oracle Workflow User DEFINING SOURCE METADATA Data warehouse implementation: Typical steps Difference Between Obtaining Relational and Flat File Source Metadata Creating Flat File Module Sampling Simple Delimited File Sampling Multi-record Flat File Creating an Oracle Module Selecting the Tables for Import DEFINING ETL MAPPINGS FOR STAGING DATA Purpose of a Staging Area Define OWB Mappings Mapping Editor Interface: Grouping, Ungrouping, and Spotlighting Creating External Tables Create and Bind process Levels of Synchronizing Changes Using the Automapper in the Mapping Editor Set loading type and target load ordering USING THE DATA TRANSFORMATION OPERATORS Component Palette Using a Joiner Lookup Operator: Handling Multiple Match Rows Using the Subquery Filter Operator Using the Set, Sequence, and Splitter Operators Pivot and Unpivot Operators Using the Aggreagator, Constant, Transformation, and Pre/Post Mapping Operators Deploying and Executing in Projects Navigator Panel CLEANSING AND MATCH-MERGING NAME AND ADDRESS DATA Integrating Data Quality into ETL Name and Address Data Cleansing Name and Address Server Name and Address Software Providers Settings in the Name and Address Operator Reviewing a Name and Address Mapping Consolidating Data Using the Match Merge Operator Using the Match Merge Operator in a Mapping USING PROCESS FLOWS Process Flow Concepts Creating a Process Flow Module, a Process Flow Package and a Process Flow Types of Activities: Fork, And, Mapping, End Activity Creating Transitions Between Activities Some More Activities: Manual, SQLPLUS, Email Generating the Process Flow Package DEPLOYING AND REPORTING ON ETL JOBS Logical Versus Physical Implementation Setting Object Configuration Deployment Concepts Invoking the Control Center Manager Deploy Options and Preferences Repository Browser Starting OWB Browser Listener and the Repository Browser Browsing Design Center and Control Center Reports USING THE MAPPING DEBUGGER Overview of the Mapping Debugger Initializing a Mapping Debugging Session Preparing the testing environment and test data Setting breakpoints and watch points Evaluating the flow of data to detect mapping errors ENHANCING ETL PERFORMANCE Performance Tuning at Various Levels Performance-Related Parameters in ETL Design Configuring Mappings for Operating Modes, DML Error Logging, Commit Control, and Default Audit Levels Enabling Partition Exchange Loading (PEL) for Targets Performance-Related Parameters in Schema Design Configuring Indexes, Partitions, Constraints Enabling Parallelism and Parallel DML Setting Tablespace Properties and Gathering Schema Statistics MANAGING BACKUPS, DEVELOPMENT CHANGES, AND SECURITY Overview of Metadata Loader Utilities (MDL) Managing Metadata Changes by Using Snapshots Using Change Manager Version Management of Design Objects Graphical UI for Security Management Object-Level Security Setting Security Parameters INTEGRATING WITH ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION (OBI EE) Business Justification: Tools Integration Integrating with OBI EE and OBI SE Transferring BI Metadata to OBI EE Server Setting Up the UDML File Location Deriving the BI Metadata (OBI EE) Deploying the BI Module Converting the UDML File for OBI EE Oracle BI Admin and Answers Tool APPENDIX B: CREATING EXPERTS Harnessing OWB Power and Complexity for New Users OWB "Experts": Directed Guidance and Knowledge Management Creating an Expert Starting an Expert Creating Your Own Custom Dialog Scenario: ROLAP to MOLAP in Five Easy Steps Scenario: Expert for Creating External Table APPENDIX C: USING DIAGNOSIS AND DEBUGGING TECHNIQUES Collecting Information Before Contacting Oracle Support Sequence Used by Oracle Support Representatives to Process Calls Activating Debugging and Logging for Full Java Debug Trace Activating Tracing Using the Service_Doctor.sql Script Troubleshooting and Diagnosing Errors in Control Center Agent (CCA) Run-Time Views and Utilities Online Warehouse Builder Resources