Data Warehouse Training
Course Duration
Offline / Online Training & Projects & Practical Sessions
Eligibility
Graduates or Diploma Holders
Course Fee
GST will be charged at checkout Flexible Payment Options Available
In computing, a data warehouse, also known as an enterprise data warehouse, is a system used for reporting and data analysis and is considered a core component of business intelligence. DWs are central repositories of integrated data from one or more disparate sources.A data warehouse is a type of data management system that is designed to enable and support business intelligence (BI) activities, especially analytics. Data warehouses are solely intended to perform queries and analysis and often contain large amounts of historical data.
Syllabus
- Introduction Of Data Warehouse
- What Is Data Warehouse?
- Data Warehouse Architecture
- Explain OLTP, OLAP
- Explain Schemas
- First Steps
- What is ETL?
- What is Informatica?
- Informatica Architecture Overview
- Explain Informatica Power Center Components
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
- Power Center Admin Console
- Sources
- Relational Sources(Data Bases)
- Files Sources(Flat File, Xml, Cobol)
- Targets
- Relational Targets(Data Bases)
- Files Targets
- Transformations
- What is Transformation
- Type Of Transformation
- Active Transformations
- Passive Transformations
- Expression Transformation
- Filter Transformation
- Router Transformation
- Sorter Transformation
- Rank Transformation
- Source Qualifier Transformation
- Aggregator Transformation
- Joiner Transformation
- Sequence Generator Transformation
- SQL Transformation
- Stored Procedure Transformation
- Lookup(Different Type Of Lookup) Transformation
- Union Transformation
- Normalizer Transformation
- Update Strategy Transformation
- Slowly Changing Dimension
- SCD Type-1
- SCD Type-2(Date, Flag And Version)
- SCD Type-3
- Workflow Manager
- Create Reusable Tasks
- Workflows, Sessions And Worklets
- Task
- Session
- Decision Task
- Control Task
- Event Wait Task
- Timer Task
- Monitoring Workflows And Debugging Errors
- Indirect Loading
- Constraint Based Load Ordering
- Target Load Plan
- Worklet, Mapplet
- Reusable Transformation
- Migration
- Xml Migration & Folder Copy
- Scheduling Workflow
- Parameter and Variables
- Xml Source, Target and Transformations
- Performance Tuning
- Partition
- Pipeline Partition
- Dynamic Partition
- Pushdown optimization
Athulkrishna Prakash
Software Developer [ MEARN ] | Tamchery Solutions
Mohammad Anees A A
Technical Specialist | Cyber Park
V S Sreedevi
Python Developer | Infotura Solutions
Dhaneesh v jayakumaran
Software Developer | Mdigitz Soft Solutions
ABDUL LATHEEF M M
Software Tester | Growtech Software Private Limited
Sreelakshmi S
Software Tester | KOKONET Technologies
Ardra Sasidharan
Junior Developer | Nav Technologies
Snehapriya ES
Software Testers | KOKONET Technologies
Explore Other Courses
Choose from our comprehensive list of industry-standard courses designed to get you hired.
Terraform Online Training
Flutter
RestExpress Training
Python Basics + Java Basics + CPP Basics
Spark
Software Testing with AI (Manual Testing)
What Students Say
Course : Software Testing With ISTQB Training I highly recommend our tutors Twinkle ma'am, Jayasudha ma'am and Vidhya ma'am at Rogersoft to anyone looking for software testing course as they are very patient and understanding making it easy to ask questions and clarify doubts. They've helped me refresh my knowledge even after a career gap with their proper guidance and support.
Course : Software Testing with AI- With ISTQB Training I pursued the Software Testing course with ISTQB training at Rogersoft Technologies. The course is well-structured and helped me build a strong foundation and confidence in software testing. Special thanks to the mentors Twinkle ma’am, Jayasudha ma’am, and Vidhya ma’am for their guidance and support throughout the training.
Course : JMeter, Playwright Automation Training I recently did JMeter training here with Sandeep sir and I thoroughly enjoyed the course as all the sessions were explained very clearly and professionally and his knowledge on this is highly commendable . Sir was very supportive and approachable throughout and hence I never hesitated to clarify my queries. Highly recommend Sandeep Sir.
I did a course on Playwright Javascript also here, with the tutor , Mr. Sreedarshan Sir and all the sessions were very informative and helpful. Sir has in depth knowledge on all the topics and also encouraged the students to ask as many queries as we need. I would highly recommend Rogersoft Technologies and Sreedarshan Sir.
Course : DevOps The DevOps training program was conducted effectively. The instructor explained concepts clearly and ensured proper understanding through practical demonstrations. The sessions were interactive, and support was provided whenever clarification was needed. It was a valuable learning experience.
Course : DevOps The instructor demonstrated strong subject knowledge and delivered the DevOps sessions in a systematic manner. Real-time examples and hands-on practice helped in understanding industry-relevant tools. Overall, the training met expectations.
Course : ISTQB I have successfully completed the ISTQB certification after attending the course at Rogersoft. The trainers were very supportive, and the sessions were easy to understand. Daily questions and discussions helped reinforce the concepts, making the learning process more effective. Overall, it was a good learning experience.
Course : Asp.Net Web API Training I had done .NET course at Rogersoft.. it was really nice experience since the training was practical oriented and the trainer was really helpful… thank you Rogersoft and the team
Course : Data Analytics I recently completed the Data Analytics course from Rogersoft Technologies and overall I had a positive learning experience. The excellent teaching by the instructor made it a highly valuable learning experience.
Course : Full Stack - .Net, React, SQL The classes were really good. I had no experience on React and was able to learn it easily with Rogersoft Technologies. Manoj sir was really good and he explained every single thing in a very understandable way and going to the deep level as well. He also explain every topics n number of times until you understand it clearly. He taught us based on the latest version and tools. Overall the classes were too good. Happy with the entire team and classmates too!!! Thank you!!!
Course : Software Testing (Combo) - 3 months I recently joined Rogersoft Technologies and I am thoroughly impressed with the experience so far. The mentors here are exceptional in their teaching methods, ensuring that every concept is well understood. Additionally, the entire staff is incredibly welcoming and professional, making the learning environment very supportive and enjoyable. I highly recommend Rogersoft to anyone looking to further their education or skills. It truly stands out in terms of quality and commitment.