+65 8303 9150 / +65 9138 9813
INFO@XALTIUS.TECH
ETL IMPLEMENTATION USING INFORMATICA
This workshop is focused on allowing the participants to experience how to process and engineer data efficiently in Informatica.
A basic working knowledge of data engineering basics would be a plus.
What you'll learn
Data engineering is the complex task of making raw data usable to data scientists and groups within an organization. Data engineering encompasses numerous specialties of data science. In addition to making data accessible, data engineers create raw data analyses to provide predictive models and show trends for the short- and long-term. Without data engineering, it would be impossible to make sense of the huge amounts of data that are available to businesses. In this workshop, learn how Informatica, a powerful ETL enterprise tool, can help make data engineering tasks easier.
About this course
Delivering a personalized customer experience, accelerating digital transformation, and driving operational efficiency is becoming an important agenda in every organization. Enterprises continue to struggle with the various disparate sources of information, a multitude of technologies, and adapting customized legacy systems to a bursting multi-cloud environment.
Informatica is a data processing tool that is widely used for ETL to extract transform and load processing. This is an industry-leading software in the field of data processing and data governance. In this module participants will have the opportunity to explore the Informatica architecture and experience how Informatica can be a powerhouse for data processing.
Learn In No Time
Course Duration
1
Hours
1
Days
Have a look
Course Plan
In this section, participants will get a quick overview of the in-depths of Data Warehousing and the various enterprise architectures associated with Data Warehousing today.
• What is a Data Warehouse and why do we need it?
• Data Warehouse Architectures
• Recap: Dimensional Modelling
• ELT vs ETL explained
This section will allow the participants to experience how process data efficiently in Informatica. The participants will also be able to understand and apply the best practices of data warehousing and transformation.
• Understanding the Informatica Domain Architecture
• Understanding Data Types
• Exploring various Transformations
o Active and Passive
o Filter Transformations
o Lookup Transformations
o Joiner Transformations
o And others
• Learning how to create a workflow
• Working with relational/flat file sources and targets
This section will allow participants to experience some of the advanced features in Informatica. It will give the participants further insights into how far the ETL tool can be an enabler for analytics in the organization.
• Understanding functions
• Insight into the various types of tasks
• Performance Testing and Optimization
Looking for something else?
Data Analysis with Excel
Excel has also been the backbone for organizations for a very long time! This course helps you understand how you could leverage the power of Excel and SQL for data management & visualization.
Data Analysis with PowerBI
Depicting the insights from your data in the best possible manner is very important to any organization. This course provides an intensive hands on training on PowerBI for storytelling and analytics!
Data Analysis with MicroStrategy
MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad-hoc queries, thresholds and alerts, and automated report distribution.