In this classic or custom 3-day big data integration training, your will be able to leverage your Informatica skills to harness the power of Big Data for your organization.
Module 1: Data Warehouse Optimization
- Describe the challenges of an existing Data Warehouse
- Requirements of an optimized Data Warehouse
- Data Warehouse optimization process on Hadoop
- Discuss Hadoop Tradeoff with respect to Data Integration and Benefits of Informatica Big Data Edition
Module 2: Informatica Big Data Edition
- Describe licenses in Big Data Edition
- Operating system, Hadoop Distribution, and Data Warehouse Appliance support
- Hadoop Interaction support
- Hive, HBase, and MongoDB NOSQL support
- Complex file support
Module 3: PowerExchange on Hadoop
- Identify data to Offload to Hadoop
- Ingesting data to Hadoop: HDFS read/write
- Ingesting data to Hadoop: Hive table write
- Hadoop connections
- Session Configuration
Module 4: Informatica Developer Data Integration on Hadoop
- How to identify and offload expensive ETL/ELT workloads to Hadoop
- Architecture Deep Dive
- Create HDFS Connections
- Run mappings on Data Integration Server and in Hadoop
- Monitoring and Troubleshooting
Module 5: More on Data Integration in Hadoop with Informatica
- Challenges executing mappings in Hadoop
- Big Data Performance Tuning, Tips and Tricks
- Hive Best Practices
- Reading and writing compressed data in Hadoop
- Installation
- Hadoop Distribution configuration
Module 6: Profiling
- Profiling in Hadoop
- Drilling down on data
- Multi-object profiling
- Custom profiles
Module 7: Data Quality Exception Management
- Describe the Complex File Reader
- Create a Data Processor Transformation and describe its uses and purpose
- XMAP
- Describe the complex file writer
Module 8: HParser
- Describe the architecture and purpose of HParser
- Describe the HParser installation process
- Describe HParser jobs
Module 9: PowerExchange for HBase
- Describe HBase as a NoSQL Columnar database
- Describe the PowerExchange for HBase adapter
- Infer HBase data structure
- RWrite and Write HBase
- Push HBase mappings into a Hadoop cluster
