title
Informatica Tutorial For Beginners Part 1 | Informatica PowerCenter Training | Informatica | Edureka
description
( Informatica Tutorial - https://www.edureka.co/informatica-certification-training )
Watch Sample Class recording: http://www.edureka.co/informatica?utm_source=youtube&utm_medium=webinar&utm_campaign=informatica-17-6-15
Edureka's Informatica PowerCenter 9.X Developer & Admin Course will introduce the participants to work with the PowerCenter. Developers can use Informatica to create, execute, as well as administer, monitor and schedule ETL processes and understand how these are used in data mining operations. The course will also cover Installation & Configuration of Informatica PowerCenter 9.X and basic Administration Activities. Participants will also get to implement one project towards the end of the course.
This video helps you to learn following topics :
1.ETL Using Informatica Power center
2.The Information Economy
3.ETL - an Overview
4.The Informatica Platform
5.Why Informatica
6.Informatica Partners and Customers
7.Informatica Architecture Overview and Components
8.Usecase1 - Loading Product Dimension table using slowly changing dimension (SCD)
9.Usecase2 - Popular Sales Summary table using Incremental aggression
10.Job Trends
11.Scope of this Course
Edureka is a New Age e-learning platform that provides Instructor-Led Live, Online classes for learners who would
prefer a hassle free and self paced learning environment, accessible from any part of the world.
The topics related to Informatica have extensively been covered in our course 'Informatica PowerCenter 9.X Developer & Admin’.
For more information, Please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll free).
detail
{'title': 'Informatica Tutorial For Beginners Part 1 | Informatica PowerCenter Training | Informatica | Edureka', 'heatmap': [{'end': 3096.893, 'start': 2704.033, 'weight': 0.782}, {'end': 3518.39, 'start': 3404.698, 'weight': 0.746}, {'end': 4274.304, 'start': 4219.954, 'weight': 0.723}], 'summary': "This tutorial covers an overview of informatica power center 9.x, in-depth training on client tools, transformation concepts, service-oriented architecture, scaling options, metadata, domain, architecture, and gateway nodes. it includes market presence with 8106 million revenue in 2012, 5000 customers in 82 countries, and 28 direct presence countries, as well as an overview of informatica's data integration solutions and capabilities.", 'chapters': [{'end': 65.128, 'segs': [{'end': 73.735, 'src': 'embed', 'start': 43.004, 'weight': 0, 'content': [{'end': 45.446, 'text': 'The class recording will be available in LMS for a lifetime.', 'start': 43.004, 'duration': 2.442}, {'end': 48.875, 'text': "It's having 24-7 post-class support.", 'start': 45.953, 'duration': 2.922}, {'end': 51.297, 'text': "We'll have module-wise quiz.", 'start': 49.796, 'duration': 1.501}, {'end': 53.799, 'text': 'And then we have project work.', 'start': 52.458, 'duration': 1.341}, {'end': 57.342, 'text': "And we'll have very valuable certificate from Edureka.", 'start': 54.139, 'duration': 3.203}, {'end': 62.206, 'text': 'So after the completion of the course, there will be project assignment.', 'start': 57.682, 'duration': 4.524}, {'end': 65.128, 'text': 'Upon the successful completion of the project assignment,', 'start': 62.546, 'duration': 2.582}, {'end': 73.735, 'text': 'there will be a very valuable certificate available from Edureka after the completion of the project curriculum.', 'start': 65.128, 'duration': 8.607}], 'summary': 'Lifetime access to class recording, 24/7 support, quizzes, project work, and valuable certificate from edureka', 'duration': 30.731, 'max_score': 43.004, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM43004.jpg'}], 'start': 0.658, 'title': 'Informatica power center 9.x overview', 'summary': 'Covers an overview of informatica power center 9.x, including lifetime access to class recordings, 24-7 post-class support, module-wise quiz, project work, and a valuable certificate from edureka.', 'chapters': [{'end': 65.128, 'start': 0.658, 'title': 'Informatica power center 9.x overview', 'summary': 'Covers the informatica power center 9.x overview, highlighting its lifetime access to class recordings, 24-7 post-class support, module-wise quiz, project work, and a valuable certificate from edureka.', 'duration': 64.47, 'highlights': ['The course offers lifetime access to class recordings and 24-7 post-class support, ensuring continuous learning and assistance (e.g., support, clarifications) (e.g., 24/7 post-class support).', 'The module-wise quiz and project work provide a comprehensive learning experience with practical assignments (e.g., module-wise quiz, project work).', 'Upon successful completion, participants will receive a valuable certificate from Edureka, enhancing their credentials and recognition in the field (e.g., valuable certificate from Edureka).']}], 'duration': 64.47, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM658.jpg', 'highlights': ['The course offers lifetime access to class recordings and 24-7 post-class support, ensuring continuous learning and assistance (e.g., support, clarifications) (e.g., 24/7 post-class support).', 'Upon successful completion, participants will receive a valuable certificate from Edureka, enhancing their credentials and recognition in the field (e.g., valuable certificate from Edureka).', 'The module-wise quiz and project work provide a comprehensive learning experience with practical assignments (e.g., module-wise quiz, project work).']}, {'end': 1455.421, 'segs': [{'end': 314.218, 'src': 'embed', 'start': 290.598, 'weight': 0, 'content': [{'end': 297.586, 'text': "So it's basically a very long topic and have around some around 150 slides.", 'start': 290.598, 'duration': 6.988}, {'end': 303.911, 'text': "I've tried to cover most of the aspects that are possible from Informatica Power Center side.", 'start': 298.885, 'duration': 5.026}, {'end': 311.521, 'text': 'However, if something is missed and if you find that something is missed, you can post that in the forum and we can discuss that topic as well.', 'start': 304.392, 'duration': 7.129}, {'end': 314.218, 'text': "Yeah, then we'll have the repository manager.", 'start': 312.136, 'duration': 2.082}], 'summary': 'Covered various aspects of informatica power center with around 150 slides.', 'duration': 23.62, 'max_score': 290.598, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM290598.jpg'}, {'end': 742.979, 'src': 'embed', 'start': 714.3, 'weight': 1, 'content': [{'end': 726.363, 'text': 'but note toward the point is it has around 5,000 customers spread over 82 countries and Informatica has got direct presence in 28 countries, yeah.', 'start': 714.3, 'duration': 12.063}, {'end': 736.698, 'text': 'So it has got a larger customer base, And people are using Informatica for their data integration solutions.', 'start': 727.403, 'duration': 9.295}, {'end': 742.979, 'text': 'So a lot of companies are using this as Informatica to perform their data integration activities.', 'start': 737.338, 'duration': 5.641}], 'summary': 'Informatica has around 5,000 customers in 82 countries, with a direct presence in 28 countries, and is widely used for data integration solutions.', 'duration': 28.679, 'max_score': 714.3, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM714300.jpg'}, {'end': 787.068, 'src': 'embed', 'start': 759.5, 'weight': 2, 'content': [{'end': 765.722, 'text': 'Now there are a wide range of products available under the Informatica product suite that helps satisfy the data integration requirements.', 'start': 759.5, 'duration': 6.222}, {'end': 769.583, 'text': 'The product portfolio is like data integration ETL.', 'start': 766.302, 'duration': 3.281}, {'end': 775.264, 'text': 'This is basically where your power center software lies.', 'start': 770.323, 'duration': 4.941}, {'end': 787.068, 'text': 'Apart from that, Informatica has ILM information loss, elastic management, complex event processing data, masking data, quality data replication,', 'start': 775.745, 'duration': 11.323}], 'summary': 'Informatica offers a wide range of products for data integration, including etl and ilm, with a diverse product portfolio.', 'duration': 27.568, 'max_score': 759.5, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM759500.jpg'}, {'end': 1220.79, 'src': 'embed', 'start': 1195.359, 'weight': 3, 'content': [{'end': 1205.644, 'text': 'so informatica data quality provides clean, high quality data, regardless of the size, data format, platform or technology, to the business.', 'start': 1195.359, 'duration': 10.285}, {'end': 1209.064, 'text': 'so it helps in validating and improving address information.', 'start': 1205.644, 'duration': 3.42}, {'end': 1212.586, 'text': "I'll say that why I specified the address information here,", 'start': 1209.404, 'duration': 3.182}, {'end': 1220.79, 'text': 'and then profiling and cleansing business data and implementing or governing practice and to ensure that the data quality comments are made.', 'start': 1212.586, 'duration': 8.204}], 'summary': 'Informatica data quality ensures clean, high-quality data for businesses, including address validation and improvement.', 'duration': 25.431, 'max_score': 1195.359, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM1195359.jpg'}], 'start': 65.128, 'title': 'Informatica power center training', 'summary': "Provides in-depth training on informatica power center, covering client tools, advanced transformation concepts, debugging, error handling, cas, and performance optimization, with 150 slides on development and administration, repository manager, technical architecture, etl scenarios, and best practices. it also includes market presence, product suite, and versions, with 8106 million revenue in 2012, 5000 customers in 82 countries, and 28 direct presence countries, as well as an overview of informatica's data integration solutions and their capabilities.", 'chapters': [{'end': 290.318, 'start': 65.128, 'title': 'Informatica power center training overview', 'summary': 'Covers in-depth training on informatica power center, including client tools for sessions and workflows, advanced transformation concepts, debugging and troubleshooting, error handling and recovery, cas, and performance optimization.', 'duration': 225.19, 'highlights': ['The chapter includes training on client tools for sessions and workflows. This involves practical use of Power Center Designer and discussion on sessions and workflows, aiming to familiarize learners with the concepts and tools.', 'Advanced transformation concepts like Java and XML transformation are covered. Specific knowledge on Java and XML transformation is emphasized for dealing with respective language or format, facilitating comprehensive understanding of transformation concepts.', 'Debugging, troubleshooting, error handling, and recovery are important concepts covered in the training. The training emphasizes the significance of these concepts for ETL job development, framework designing, and support and maintenance projects, providing essential knowledge for handling job failures and recovery.', 'Performance optimization is a key focus of the training. The chapter discusses best practices for optimizing performance and troubleshooting bottlenecks, essential for obtaining optimal results from Informatica Power Center.']}, {'end': 558.973, 'start': 290.598, 'title': 'Informatica power center training', 'summary': 'Covers informatica power center training, including 150 slides on development and administration, repository manager, technical architecture, installation operations, command line utilities, etl scenarios, and best practices with a focus on velocity methodology and recommended ways of using informatica.', 'duration': 268.375, 'highlights': ['The chapter covers Informatica Power Center training, including 150 slides on development and administration, repository manager, technical architecture, installation operations, command line utilities, ETL scenarios, and best practices with a focus on velocity methodology and recommended ways of using Informatica.', 'Informatica Administration Console is a web-based interface used to administer Informatica repositories, domain, and services.', 'Informatica Power Center repository manager is discussed, covering activities like creating folders, repositories, configuring domain, repositories, and migration.', 'The chapter also includes the discussion of important ETL scenarios using Informatica Power Center, such as slowly changing dimensions, incremental aggregation, constraint-based loading, handling of flat files, XML files, and Java transformation activities.', 'Best practices and velocity methodology are covered, offering recommended ways of using Informatica and perspectives based on experience from integration projects and colleagues.']}, {'end': 838.356, 'start': 558.973, 'title': 'Informatica power center overview', 'summary': "Covers informatica power center with 16 modules, including lab assignments, and discusses informatica's market presence, product suite, and versions, with 8106 million revenue in 2012, 5000 customers in 82 countries, and 28 direct presence countries.", 'duration': 279.383, 'highlights': ["Informatica's market presence and revenue Informatica had a revenue of 8106 million in 2012, with 5000 customers in 82 countries and direct presence in 28 countries.", "Informatica's product suite Informatica offers a wide range of products, including data integration ETL, ILM, elastic management, complex event processing, data masking, data quality, data replication, data virtualization, master data management, and alter messaging.", 'Informatica Power Center versions The current versions available for Informatica Power Center is 9.5.1, with 9.6 being the latest.', 'Lab assignments and module coverage The chapter includes 16 modules, with lab assignments for all modules except module one and two, and some assignments are to be done in spare time due to time constraints.']}, {'end': 1455.421, 'start': 838.936, 'title': 'Informatica data integration solutions', 'summary': "Provides an overview of informatica's data integration solutions, including specific data formats, tools for various industries, and the capabilities of different products, such as data masking, data quality, and data virtualization.", 'duration': 616.485, 'highlights': ['Informatica offers tools for various industries, including healthcare, to process specific formatted data, such as HIPAA for healthcare industry, SWIFT for financial industry, and EDIs for electronic data interchange. Tools available for specific industries like healthcare, financial industry, and electronic data interchange.', 'Informatica provides tools for data integration, such as data quality, data masking, and data replication, which ensure clean, high-quality data, mask sensitive information, and replicate data across platforms. Tools for data integration including data quality, data masking, and data replication.', "Informatica's data quality tool provides clean, high-quality data for business, including address validation for around 200 countries, with 100% match for addresses in grade A countries. Address validation for around 200 countries with 100% match for grade A countries.", "Informatica's data replication tool is a highly scalable, reliable, and non-disruptive software for real-time transaction replication across different databases. Highly scalable, reliable, and non-disruptive software for real-time transaction replication.", 'Informatica provides a data virtualization solution that creates a layer to access underlying data sources and insulates them from change, offering a single, scalable architecture for data integration. Data virtualization solution creating a single, scalable architecture for data integration.']}], 'duration': 1390.293, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM65128.jpg', 'highlights': ['The chapter covers Informatica Power Center training, including 150 slides on development and administration, repository manager, technical architecture, installation operations, command line utilities, ETL scenarios, and best practices with a focus on velocity methodology and recommended ways of using Informatica.', "Informatica's market presence and revenue Informatica had a revenue of 8106 million in 2012, with 5000 customers in 82 countries and direct presence in 28 countries.", "Informatica's product suite Informatica offers a wide range of products, including data integration ETL, ILM, elastic management, complex event processing, data masking, data quality, data replication, data virtualization, master data management, and alter messaging.", "Informatica's data quality tool provides clean, high-quality data for business, including address validation for around 200 countries, with 100% match for addresses in grade A countries."]}, {'end': 2249.213, 'segs': [{'end': 1486.294, 'src': 'embed', 'start': 1455.801, 'weight': 4, 'content': [{'end': 1462.105, 'text': "It's not available for all the countries, basically, but for some of the countries, you can get even an exact match for this particular address.", 'start': 1455.801, 'duration': 6.304}, {'end': 1466.997, 'text': 'Then we have got AgentLogic, which Informatica acquired in 2009.', 'start': 1462.665, 'duration': 4.332}, {'end': 1473.203, 'text': 'It is basically complex event processing software and complex event processing and operation intelligence software.', 'start': 1466.997, 'duration': 6.206}, {'end': 1475.265, 'text': 'And then we have got Cyprian.', 'start': 1474.144, 'duration': 1.121}, {'end': 1477.507, 'text': 'Cyprian is the MDM tool for Informatica.', 'start': 1475.305, 'duration': 2.202}, {'end': 1486.294, 'text': 'So whatever we are knowing as Informatica MDM now, that was basically Cyprian which Informatica acquired in 2010.', 'start': 1477.827, 'duration': 8.467}], 'summary': "Informatica's acquisitions include agentlogic in 2009 and cyprian in 2010 for mdm tools.", 'duration': 30.493, 'max_score': 1455.801, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM1455801.jpg'}, {'end': 1838.396, 'src': 'embed', 'start': 1810.24, 'weight': 3, 'content': [{'end': 1813.004, 'text': "You can use that at a bare minimum, I'm talking about.", 'start': 1810.24, 'duration': 2.764}, {'end': 1818.071, 'text': 'So at a bare minimum, you can download Oracle 10G Express and you can go ahead with installation of Informatica.', 'start': 1813.385, 'duration': 4.686}, {'end': 1823.646, 'text': 'how to prepare for certification specifically.', 'start': 1821.385, 'duration': 2.261}, {'end': 1829.29, 'text': 'so yeah, I mean, like you know, the concepts of Informatica will be required as well.', 'start': 1823.646, 'duration': 5.644}, {'end': 1838.396, 'text': "as you know, you'll have to register for this particular certification and Informatica will provide you the set of the sample questions.", 'start': 1829.29, 'duration': 9.106}], 'summary': 'Prepare for informatica certification with oracle 10g express and concepts of informatica. informatica provides sample questions.', 'duration': 28.156, 'max_score': 1810.24, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM1810240.jpg'}, {'end': 1984.541, 'src': 'embed', 'start': 1959.592, 'weight': 2, 'content': [{'end': 1965.194, 'text': "And as well as it's a very, very simple for developing, maintaining, and administrating.", 'start': 1959.592, 'duration': 5.602}, {'end': 1973.037, 'text': 'So the interfaces that Informatica Power Center is providing to you is very intuitive and you will not have to spend much of our time to understand that.', 'start': 1965.454, 'duration': 7.583}, {'end': 1974.978, 'text': 'what it what this particular thing is.', 'start': 1973.037, 'duration': 1.941}, {'end': 1977.298, 'text': 'you know how this particular thing is going to work.', 'start': 1974.978, 'duration': 2.32}, {'end': 1979.979, 'text': "And you know it's a from the user friendliness.", 'start': 1977.859, 'duration': 2.12}, {'end': 1984.541, 'text': 'Informatica is a kind of, you know, one of the top choice for that business.', 'start': 1979.979, 'duration': 4.562}], 'summary': 'Informatica power center is user-friendly and a top choice for businesses.', 'duration': 24.949, 'max_score': 1959.592, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM1959592.jpg'}, {'end': 2031.976, 'src': 'embed', 'start': 2004.059, 'weight': 0, 'content': [{'end': 2011.384, 'text': 'so in that case, Informatica Power Center is one of the easiest tool to learn and that concepts and even if that easiest,', 'start': 2004.059, 'duration': 7.325}, {'end': 2015.147, 'text': 'it perform the most complex tasks by those easiest means.', 'start': 2011.384, 'duration': 3.763}, {'end': 2021.913, 'text': 'and apart from that, the availability for Informatica Power Center in both windows and in news with environments,', 'start': 2015.147, 'duration': 6.766}, {'end': 2031.976, 'text': 'enable business to get the data integration solution need fulfilled based on their you know that budget, the system budget and everything.', 'start': 2021.913, 'duration': 10.063}], 'summary': 'Informatica power center is an easy tool, available on windows and linux, enabling data integration solutions within budget.', 'duration': 27.917, 'max_score': 2004.059, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2004059.jpg'}, {'end': 2160.301, 'src': 'embed', 'start': 2128.448, 'weight': 1, 'content': [{'end': 2131.531, 'text': 'So what is service-oriented architecture? That will be discussed later.', 'start': 2128.448, 'duration': 3.083}, {'end': 2139.058, 'text': 'So from version 8.x onwards, that will not be 9.x, that will be 8.x onwards, Power Center has moved to the service-oriented architecture.', 'start': 2131.811, 'duration': 7.247}, {'end': 2145.663, 'text': 'And from 9.x, they have consolidated their other relevant tool in a single Informatica platform.', 'start': 2139.458, 'duration': 6.205}, {'end': 2150.107, 'text': 'And those are offered to the customer as a whole.', 'start': 2146.364, 'duration': 3.743}, {'end': 2160.301, 'text': 'with the restriction provided by the license available from the Informatica.', 'start': 2152.139, 'duration': 8.162}], 'summary': 'Informatica power center moved to service-oriented architecture from version 8.x onwards, and from 9.x, relevant tools were consolidated into a single platform offered to customers with license restrictions.', 'duration': 31.853, 'max_score': 2128.448, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2128448.jpg'}], 'start': 1455.801, 'title': 'Informatica power center', 'summary': 'Covers informatica power center resources such as agentlogic and cyprian acquisitions, free resources on the corporate website, informatica university, and customer support. it also provides an overview of its features, capabilities, system requirements, oracle compatibility, certification preparation, connectors, and version updates.', 'chapters': [{'end': 1734.786, 'start': 1455.801, 'title': 'Informatica power center resources', 'summary': 'Highlights the resources available from informatica, including the acquisition of agentlogic and cyprian, the availability of free resources on the corporate website, and the details about informatica university and customer support. it also covers the availability of certifications and documentation, including knowledge base and technical support, emphasizing the strong technical support available 24/7.', 'duration': 278.985, 'highlights': ['Informatica provides free resources on their corporate website, including AgentLogic and Cyprian acquisitions, available documentation, and online support for customers. Free resources on corporate website, AgentLogic and Cyprian acquisitions, available documentation, online support for customers', 'Informatica University offers information on certifications, learning paths, and documentation, while customer portal is exclusively available for Informatica customers. Informatica University offerings, exclusive customer portal', 'Informatica provides detailed documentation, knowledge base, technical support, and strong 24/7 technical support for customers. Detailed documentation, knowledge base, technical support, 24/7 availability']}, {'end': 2249.213, 'start': 1737.122, 'title': 'Informatica power center overview', 'summary': 'Covers the overview of informatica power center, including its features, capabilities, and system requirements, with a focus on oracle compatibility, certification preparation, connectors, and version updates.', 'duration': 512.091, 'highlights': ['Informatica Power Center is an ETL tool that offers scalable and high-performance data integration software, with connectors available for various business systems and web services. Informatica Power Center is highlighted as a scalable and high-performance data integration software with connectors available for various business systems and web services, providing a comprehensive solution for data integration needs.', 'Oracle 10G Express is recommended as a minimum requirement for installing and working with Informatica, with emphasis on certification preparation and sample question availability from Informatica. The recommendation of Oracle 10G Express as a minimum requirement for installing and working with Informatica, along with the emphasis on certification preparation and availability of sample questions from Informatica, is highlighted as essential for aspiring users.', "Informatica Power Center's user-friendly interface and availability on both Unix and Windows environments make it an accessible and preferred tool for data integration needs, aligning with budget and system requirements. The user-friendly interface and availability of Informatica Power Center on both Unix and Windows environments, making it accessible and preferred for data integration needs, are highlighted as factors aligning with budget and system requirements.", "Informatica Power Center's shift to service-oriented architecture from version 8.x onwards, and the consolidation of relevant tools in a single platform offered with license restrictions, is discussed, emphasizing the architectural changes and licensing implications. The shift to service-oriented architecture from version 8.x onwards and the consolidation of relevant tools in a single platform offered with license restrictions, with a focus on architectural changes and licensing implications, is highlighted as crucial information for users.", "Informatica's compatibility with VSAM files for data retrieval and the recommendation of using Oracle 10G Express Edition for reduced resource consumption on personal machines are highlighted as practical considerations for users. The compatibility with VSAM files for data retrieval and the recommendation of using Oracle 10G Express Edition for reduced resource consumption on personal machines are highlighted as practical considerations for users."]}], 'duration': 793.412, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM1455801.jpg', 'highlights': ['Informatica Power Center is highlighted as a scalable and high-performance data integration software with connectors available for various business systems and web services, providing a comprehensive solution for data integration needs.', 'The shift to service-oriented architecture from version 8.x onwards and the consolidation of relevant tools in a single platform offered with license restrictions, with a focus on architectural changes and licensing implications, is highlighted as crucial information for users.', 'The user-friendly interface and availability of Informatica Power Center on both Unix and Windows environments, making it accessible and preferred for data integration needs, are highlighted as factors aligning with budget and system requirements.', 'The recommendation of Oracle 10G Express as a minimum requirement for installing and working with Informatica, along with the emphasis on certification preparation and availability of sample questions from Informatica, is highlighted as essential for aspiring users.', 'Informatica provides free resources on their corporate website, including AgentLogic and Cyprian acquisitions, available documentation, and online support for customers.']}, {'end': 2674.934, 'segs': [{'end': 2358.123, 'src': 'embed', 'start': 2334.326, 'weight': 0, 'content': [{'end': 2344.539, 'text': 'because Informatica 9.x consolidated all set of Informatica platform which are relevant to the data integration, like data quality,', 'start': 2334.326, 'duration': 10.213}, {'end': 2351.981, 'text': 'data analyst and everything, into one platform, and it gives you the opportunity to use everything,', 'start': 2344.539, 'duration': 7.442}, {'end': 2355.882, 'text': 'provided you have paid the license cost for each and every services.', 'start': 2351.981, 'duration': 3.901}, {'end': 2358.123, 'text': "So it's the license that will restrict you.", 'start': 2355.922, 'duration': 2.201}], 'summary': 'Informatica 9.x consolidates data integration, data quality, and data analyst into one platform, restricted by paid licenses.', 'duration': 23.797, 'max_score': 2334.326, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2334326.jpg'}, {'end': 2407.508, 'src': 'embed', 'start': 2380.431, 'weight': 6, 'content': [{'end': 2386.678, 'text': 'you can buy a basic license for Informatica Power Center standard edition and you can carry on your work within.', 'start': 2380.431, 'duration': 6.247}, {'end': 2393.401, 'text': 'from a power center center is a letter you have got a need for include your data quality solution as well, right?', 'start': 2386.678, 'duration': 6.723}, {'end': 2403.186, 'text': 'so then you can even buy the Delta license from Informatica Corporation and then you know you can enable that particular features in your product as well.', 'start': 2393.401, 'duration': 9.785}, {'end': 2407.508, 'text': 'so the aim is to provide improved performance and high availability.', 'start': 2403.186, 'duration': 4.322}], 'summary': 'Buy a basic license for informatica power center, and add data quality solution with delta license for improved performance and high availability.', 'duration': 27.077, 'max_score': 2380.431, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2380431.jpg'}, {'end': 2540.282, 'src': 'embed', 'start': 2515.6, 'weight': 2, 'content': [{'end': 2521.302, 'text': 'So Informatica is a certified partner for SAP data migration or data integration you can say.', 'start': 2515.6, 'duration': 5.702}, {'end': 2525.323, 'text': 'So SAP certified partner for SAP data migration.', 'start': 2521.642, 'duration': 3.681}, {'end': 2533.906, 'text': 'So we can connect to SAP, get the relevant data from there and perform the transformation within it and again even push to SAP.', 'start': 2525.343, 'duration': 8.563}, {'end': 2540.282, 'text': 'So we can connect to SAP R3, the ERP system SAP perform the transformation and push the data to SAP BW.', 'start': 2534.166, 'duration': 6.116}], 'summary': 'Informatica is a certified sap partner for data migration and integration, connecting to sap r3 and pushing data to sap bw.', 'duration': 24.682, 'max_score': 2515.6, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2515600.jpg'}, {'end': 2635.516, 'src': 'embed', 'start': 2584.058, 'weight': 1, 'content': [{'end': 2588.16, 'text': 'interest in cloud-based solution, so they will have a huge growth in their data as well.', 'start': 2584.058, 'duration': 4.102}, {'end': 2597.757, 'text': 'so, in order to skill that, they have to scale up their infrastructure as well, Informatica provides a cost efficient and, you know,', 'start': 2588.16, 'duration': 9.597}, {'end': 2601.52, 'text': 'scalable infrastructure for that particular power center.', 'start': 2597.757, 'duration': 3.763}, {'end': 2603.922, 'text': 'Power center architecture has been made in like that.', 'start': 2601.54, 'duration': 2.382}, {'end': 2613.029, 'text': 'so we have got option for partitioning which will enable you threaded parallel processing as well as in-premier pipeline.', 'start': 2603.922, 'duration': 9.107}, {'end': 2623.011, 'text': 'so, like you know, we can connect to the source and target parallelly to acquire the data or to push the data,', 'start': 2613.029, 'duration': 9.982}, {'end': 2633.976, 'text': 'and even we can process the transformation within Informatica server parallelly to provide you the data in very low latency.', 'start': 2623.011, 'duration': 10.965}, {'end': 2635.516, 'text': 'you know the time scale basically.', 'start': 2633.976, 'duration': 1.54}], 'summary': 'Interest in cloud-based solution for huge data growth. informatica provides cost-efficient and scalable infrastructure, enabling threaded parallel processing and low latency data delivery.', 'duration': 51.458, 'max_score': 2584.058, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2584058.jpg'}], 'start': 2249.593, 'title': 'Service oriented architecture and informatica 9.x', 'summary': "Discusses service oriented architecture, including its relevance to informatica's power center architecture and etl job execution, and informatica 9.x's unified data integration platform with improved performance, high availability, scalability, and connectivity with various data sources and consumers.", 'chapters': [{'end': 2334.326, 'start': 2249.593, 'title': 'Understanding service oriented architecture', 'summary': "Discusses service oriented architecture, defining it as a group of services communicating with each other, including the coordination of activities involving different services, and its relevance to informatica's power center architecture and etl job execution.", 'duration': 84.733, 'highlights': ['The chapter defines service oriented architecture as a group of services communicating with each other, involving simple data passing or coordination of activities between services.', 'Informatica has created different services to perform tasks and communicate with each other in the power center architecture and ETL job execution.', 'The services continuously execute and communicate with each other to perform a set of activities, with no specific application performing the activity.', 'The discussion covers the communication of services, how they are communicating, and how memory is being handled by the processes.']}, {'end': 2674.934, 'start': 2334.326, 'title': 'Informatica 9.x: data integration platform', 'summary': 'Discusses how informatica 9.x provides a unified data integration platform with options for licensing, improved performance, high availability, scalability, and connectivity with various data sources and consumers.', 'duration': 340.608, 'highlights': ['Informatica 9.x consolidates data integration, data quality, and data analyst into a single platform, with services restricted by licensing. Informatica 9.x consolidates various Informatica platform services into one, with licensing dictating access to specific features and services.', 'Options for purchasing basic and Delta licenses allow flexibility in enabling additional features such as data quality solutions. Informatica provides options for purchasing basic and Delta licenses, enabling the addition of features like data quality solutions as per specific needs.', 'The architecture of Informatica Power Center has been re-engineered for improved performance, high availability, and scalability. Informatica has re-engineered the architecture of Power Center to enhance performance, availability, and scalability.', 'Informatica offers connectivity with various data sources such as package applications, relational and flat files, and mid-range servers, acting as middleware for data migration and integration. Informatica provides connectivity with a wide range of data sources, serving as middleware for data migration and integration.', 'Informatica is a certified partner for SAP data migration, allowing seamless connection, transformation, and data transfer between systems. Informatica is a certified partner for SAP data migration, facilitating seamless connection, transformation, and data transfer between systems.', "Scalability features in Informatica enable efficient scaling of infrastructure to accommodate growing data demands, providing cost-efficient solutions for expanding businesses. Informatica's scalability features enable efficient infrastructure scaling to meet growing data demands, offering cost-efficient solutions for expanding businesses.", 'Parallel processing and partitioning options in Informatica Power Center enable low-latency data acquisition, transformation, and delivery for real-time data arrival scenarios. Informatica Power Center offers parallel processing and partitioning options for low-latency data acquisition, transformation, and delivery, ideal for real-time data arrival scenarios.']}], 'duration': 425.341, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2249593.jpg', 'highlights': ['Informatica 9.x consolidates data integration, data quality, and data analyst into a single platform, with services restricted by licensing.', 'The architecture of Informatica Power Center has been re-engineered for improved performance, high availability, and scalability.', 'Informatica provides connectivity with a wide range of data sources, serving as middleware for data migration and integration.', 'Informatica is a certified partner for SAP data migration, facilitating seamless connection, transformation, and data transfer between systems.', 'Scalability features in Informatica enable efficient scaling of infrastructure to accommodate growing data demands, providing cost-efficient solutions for expanding businesses.', 'Parallel processing and partitioning options in Informatica Power Center enable low-latency data acquisition, transformation, and delivery for real-time data arrival scenarios.', 'Options for purchasing basic and Delta licenses allow flexibility in enabling additional features such as data quality solutions.']}, {'end': 3219.41, 'segs': [{'end': 2701.492, 'src': 'embed', 'start': 2675.234, 'weight': 0, 'content': [{'end': 2686.162, 'text': 'So in this kind of scenario, when your processing window shrinks or your data grows, right? You need to scale up your application architecture.', 'start': 2675.234, 'duration': 10.928}, {'end': 2691.567, 'text': 'Power Center provides that options within their partitioning options.', 'start': 2687.165, 'duration': 4.402}, {'end': 2694.849, 'text': 'So partitioning is one of the options by which you can scale up your infrastructure.', 'start': 2691.587, 'duration': 3.262}, {'end': 2696.369, 'text': 'There are other options as well.', 'start': 2695.169, 'duration': 1.2}, {'end': 2701.492, 'text': 'As I said, that Power Center has got, you know, two components.', 'start': 2697.55, 'duration': 3.942}], 'summary': 'Power center offers partitioning for scaling infrastructure.', 'duration': 26.258, 'max_score': 2675.234, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2675234.jpg'}, {'end': 3096.893, 'src': 'heatmap', 'start': 2704.033, 'weight': 0.782, 'content': [{'end': 2706.874, 'text': 'The first one is a server component and the next one is a client component.', 'start': 2704.033, 'duration': 2.841}, {'end': 2712.757, 'text': 'right?. So, server component, whenever you are installing Informatica, you will have two installers available.', 'start': 2706.874, 'duration': 5.883}, {'end': 2714.218, 'text': 'One is a server installer.', 'start': 2713.217, 'duration': 1.001}, {'end': 2715.578, 'text': 'One is a client installer.', 'start': 2714.558, 'duration': 1.02}, {'end': 2720.897, 'text': 'So server installer, will basically install the services in your machine.', 'start': 2715.958, 'duration': 4.939}, {'end': 2722.137, 'text': 'The Informatica service.', 'start': 2721.317, 'duration': 0.82}, {'end': 2723.318, 'text': "if you're using a Windows machine,", 'start': 2722.137, 'duration': 1.181}, {'end': 2735.343, 'text': 'Informatica installer will install Informatica services that will be able to see from your services.msc that particular application.', 'start': 2723.318, 'duration': 12.025}, {'end': 2737.104, 'text': 'Just let me show you one thing.', 'start': 2735.863, 'duration': 1.241}, {'end': 2741.926, 'text': 'So what I was going to show you.', 'start': 2738.784, 'duration': 3.142}, {'end': 2755.844, 'text': "so whenever you will install Informatica, if you go to the services.msc application available in windows, you'll see one Informatica services.", 'start': 2741.926, 'duration': 13.918}, {'end': 2758.546, 'text': 'see one Informatica services installed.', 'start': 2755.844, 'duration': 2.702}, {'end': 2760.287, 'text': 'info service has been created right.', 'start': 2758.546, 'duration': 1.741}, {'end': 2767.17, 'text': 'so this is that service manager that is available from Informatica and this manages all other services.', 'start': 2760.287, 'duration': 6.883}, {'end': 2774.379, 'text': "so now this is the real service that is available and other services that I'm talking about here Repository services, integrated services.", 'start': 2767.17, 'duration': 7.209}, {'end': 2775.779, 'text': 'they are logical segregation.', 'start': 2774.379, 'duration': 1.4}, {'end': 2778.901, 'text': 'they are logical services but they perform the different activities.', 'start': 2775.779, 'duration': 3.122}, {'end': 2781.782, 'text': 'but they are logical services and they will be available.', 'start': 2778.901, 'duration': 2.881}, {'end': 2785.804, 'text': 'they will be seen to you from your administrator console.', 'start': 2781.782, 'duration': 4.022}, {'end': 2791.146, 'text': "I'll show you where to see that integration service and where to see that repository service.", 'start': 2785.904, 'duration': 5.242}, {'end': 2796.689, 'text': 'So these are the client tools available from Informatica.', 'start': 2793.988, 'duration': 2.701}, {'end': 2804.996, 'text': 'repository manager, the power center designer, power center workflow manager, power center workflow monitor, and power center administrator console.', 'start': 2797.461, 'duration': 7.535}, {'end': 2809.312, 'text': 'Yeah, just a moment.', 'start': 2808.752, 'duration': 0.56}, {'end': 2816.577, 'text': 'So, I mean, the logos are not actually appropriate with respect to the Informatica provided logo, just designed in a different way.', 'start': 2809.693, 'duration': 6.884}, {'end': 2824.263, 'text': "So, repository manager, as I said, you know, it's more inclined to the administrative work, like you know,", 'start': 2816.978, 'duration': 7.285}, {'end': 2834.349, 'text': 'deployment of that workflows to one environment, to another environment, creation of the folders, looking at that session, execution time, et cetera.', 'start': 2824.263, 'duration': 10.086}, {'end': 2839.113, 'text': 'and you know, like assigning permissions to the folders, etc.', 'start': 2834.349, 'duration': 4.764}, {'end': 2846.158, 'text': 'Power Center Designer is the main tool for any developer who is developing Informatica mapping or ETL mapping.', 'start': 2839.594, 'duration': 6.564}, {'end': 2848.179, 'text': 'It has got the transformations.', 'start': 2846.758, 'duration': 1.421}, {'end': 2854.123, 'text': 'It has got the transformation which you can use to build up a new mapping.', 'start': 2848.339, 'duration': 5.784}, {'end': 2856.564, 'text': 'Power Center Walkflow Manager.', 'start': 2855.404, 'duration': 1.16}, {'end': 2862.348, 'text': 'Walkflow Manager is a place where you will build up the sessions and the workflows.', 'start': 2856.724, 'duration': 5.624}, {'end': 2878.05, 'text': 'Sessions are there to execute a mapping and when there will be a lot of sessions dependent to each other or may not be dependent to each other or performing the same set of activities or same group of activities,', 'start': 2863.644, 'duration': 14.406}, {'end': 2885.414, 'text': 'we can keep them in a single workflow and assign that flow of the sessions in that particular workflow,', 'start': 2878.05, 'duration': 7.364}, {'end': 2892.357, 'text': 'with that option of dependability or event-based dependence, everything that is available from workflow manager.', 'start': 2885.414, 'duration': 6.943}, {'end': 2894.576, 'text': 'And then there is workflow monitor.', 'start': 2892.995, 'duration': 1.581}, {'end': 2897.838, 'text': 'Workflow monitor is a place where you can monitor the jobs.', 'start': 2894.776, 'duration': 3.062}, {'end': 2906.482, 'text': "So you know, once a job has been triggered, you'll have to for mostly the support and maintenance project.", 'start': 2898.778, 'duration': 7.704}, {'end': 2916.768, 'text': "you'll have to check you know how much time it is consuming to complete that particular job and what is that throughput of that particular job current as of now.", 'start': 2906.482, 'duration': 10.286}, {'end': 2921.393, 'text': 'right and I know what is that runtime statistics available from there.', 'start': 2917.208, 'duration': 4.185}, {'end': 2925.738, 'text': 'so that is what are the session log, what is what it is writing the session log.', 'start': 2921.393, 'duration': 4.345}, {'end': 2927.92, 'text': "in case of any failure, you'll have to invest in the session log.", 'start': 2925.738, 'duration': 2.182}, {'end': 2929.462, 'text': "you'll have to invest in the workflow log.", 'start': 2927.92, 'duration': 1.542}, {'end': 2930.043, 'text': "you'll have to check.", 'start': 2929.462, 'duration': 0.581}, {'end': 2931.564, 'text': 'you know the runtime statistics.', 'start': 2930.043, 'duration': 1.521}, {'end': 2934.247, 'text': 'everything will be available from your workflow monitor.', 'start': 2931.564, 'duration': 2.683}, {'end': 2939.327, 'text': 'and then we have got power center, administrator console Administration console.', 'start': 2934.247, 'duration': 5.08}, {'end': 2941.929, 'text': 'So this is a browser, browser based application,', 'start': 2939.387, 'duration': 2.542}, {'end': 2950.312, 'text': 'while informatica provide They are consolidated information about the domain node and the different services, as well as the license.', 'start': 2941.929, 'duration': 8.383}, {'end': 2952.993, 'text': "Now I'll show you a bit about.", 'start': 2950.312, 'duration': 2.681}, {'end': 2957.195, 'text': "I'm now a bit about all these applications, other clients as well as this up there.", 'start': 2952.993, 'duration': 4.202}, {'end': 2960.217, 'text': "I'm an administration console.", 'start': 2957.235, 'duration': 2.982}, {'end': 2970.988, 'text': "Yeah, so this is the repository manager where we'll be creating the folders and will have that.", 'start': 2960.217, 'duration': 10.771}, {'end': 2975.169, 'text': "I'm an option for changing the password.", 'start': 2970.988, 'duration': 4.181}, {'end': 2976.57, 'text': 'let me connect to it.', 'start': 2975.169, 'duration': 1.401}, {'end': 2981.692, 'text': "you'll get some other options as well.", 'start': 2976.57, 'duration': 5.122}, {'end': 2984.273, 'text': 'yeah, see workflows and see.', 'start': 2981.692, 'duration': 2.581}, {'end': 2990.852, 'text': 'these are the workflows available in this particular folder under this particular repository.', 'start': 2984.273, 'duration': 6.579}, {'end': 2993.593, 'text': 'So what is folder and what is the repository?', 'start': 2991.012, 'duration': 2.581}, {'end': 3002.617, 'text': "definitely I'll tell you later when we'll install the Informatica, as well as we'll start working with Informatica Power Center Designer.", 'start': 2993.593, 'duration': 9.024}, {'end': 3007.579, 'text': 'And these are the sessions that were executed.', 'start': 3004.678, 'duration': 2.901}, {'end': 3014.802, 'text': 'No, these are the sessions that is present over there and if you see, no.', 'start': 3011.121, 'duration': 3.681}, {'end': 3027.522, 'text': 'So these are the sessions that are available and these are the mappings that are available in the repository.', 'start': 3021.598, 'duration': 5.924}, {'end': 3037.988, 'text': 'So this particular interface or the client is basically needed mostly for your application administration.', 'start': 3027.942, 'duration': 10.046}, {'end': 3047.013, 'text': 'So we have got deployment groups as well available by which using which we can migrate the workflows from one environment to another environment.', 'start': 3038.028, 'duration': 8.985}, {'end': 3053.264, 'text': 'So now apart from that, we have got, as I said, that we have got designer as well.', 'start': 3049.963, 'duration': 3.301}, {'end': 3059.187, 'text': "So this is a designer, what we will create, uh, that, uh, we'll create that mapping.", 'start': 3053.644, 'duration': 5.543}, {'end': 3061.988, 'text': 'So we have got the option for creating a mapping.', 'start': 3059.727, 'duration': 2.261}, {'end': 3067.25, 'text': 'when you say a new mapping are created and then we can add, add on the transformations available here.', 'start': 3061.988, 'duration': 5.262}, {'end': 3077.314, 'text': 'So, once we created mapping, we can add up the transformations and you know, um uh, we can start, uh, creating the ideal job, right?', 'start': 3068.31, 'duration': 9.004}, {'end': 3079.455, 'text': 'So, and this is that your.', 'start': 3077.634, 'duration': 1.821}, {'end': 3096.893, 'text': 'this is your workflow manager interface.', 'start': 3088.447, 'duration': 8.446}], 'summary': 'Informatica has server and client components, including tools for administration, development, and monitoring of etl workflows.', 'duration': 392.86, 'max_score': 2704.033, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2704033.jpg'}, {'end': 2755.844, 'src': 'embed', 'start': 2722.137, 'weight': 1, 'content': [{'end': 2723.318, 'text': "if you're using a Windows machine,", 'start': 2722.137, 'duration': 1.181}, {'end': 2735.343, 'text': 'Informatica installer will install Informatica services that will be able to see from your services.msc that particular application.', 'start': 2723.318, 'duration': 12.025}, {'end': 2737.104, 'text': 'Just let me show you one thing.', 'start': 2735.863, 'duration': 1.241}, {'end': 2741.926, 'text': 'So what I was going to show you.', 'start': 2738.784, 'duration': 3.142}, {'end': 2755.844, 'text': "so whenever you will install Informatica, if you go to the services.msc application available in windows, you'll see one Informatica services.", 'start': 2741.926, 'duration': 13.918}], 'summary': 'Installing informatica on windows adds informatica services visible in services.msc.', 'duration': 33.707, 'max_score': 2722.137, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2722137.jpg'}, {'end': 2862.348, 'src': 'embed', 'start': 2816.978, 'weight': 2, 'content': [{'end': 2824.263, 'text': "So, repository manager, as I said, you know, it's more inclined to the administrative work, like you know,", 'start': 2816.978, 'duration': 7.285}, {'end': 2834.349, 'text': 'deployment of that workflows to one environment, to another environment, creation of the folders, looking at that session, execution time, et cetera.', 'start': 2824.263, 'duration': 10.086}, {'end': 2839.113, 'text': 'and you know, like assigning permissions to the folders, etc.', 'start': 2834.349, 'duration': 4.764}, {'end': 2846.158, 'text': 'Power Center Designer is the main tool for any developer who is developing Informatica mapping or ETL mapping.', 'start': 2839.594, 'duration': 6.564}, {'end': 2848.179, 'text': 'It has got the transformations.', 'start': 2846.758, 'duration': 1.421}, {'end': 2854.123, 'text': 'It has got the transformation which you can use to build up a new mapping.', 'start': 2848.339, 'duration': 5.784}, {'end': 2856.564, 'text': 'Power Center Walkflow Manager.', 'start': 2855.404, 'duration': 1.16}, {'end': 2862.348, 'text': 'Walkflow Manager is a place where you will build up the sessions and the workflows.', 'start': 2856.724, 'duration': 5.624}], 'summary': 'Repository manager handles administrative tasks, power center designer is for informatica mapping, and walkflow manager is for building sessions and workflows.', 'duration': 45.37, 'max_score': 2816.978, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2816978.jpg'}, {'end': 2957.195, 'src': 'embed', 'start': 2927.92, 'weight': 4, 'content': [{'end': 2929.462, 'text': "you'll have to invest in the workflow log.", 'start': 2927.92, 'duration': 1.542}, {'end': 2930.043, 'text': "you'll have to check.", 'start': 2929.462, 'duration': 0.581}, {'end': 2931.564, 'text': 'you know the runtime statistics.', 'start': 2930.043, 'duration': 1.521}, {'end': 2934.247, 'text': 'everything will be available from your workflow monitor.', 'start': 2931.564, 'duration': 2.683}, {'end': 2939.327, 'text': 'and then we have got power center, administrator console Administration console.', 'start': 2934.247, 'duration': 5.08}, {'end': 2941.929, 'text': 'So this is a browser, browser based application,', 'start': 2939.387, 'duration': 2.542}, {'end': 2950.312, 'text': 'while informatica provide They are consolidated information about the domain node and the different services, as well as the license.', 'start': 2941.929, 'duration': 8.383}, {'end': 2952.993, 'text': "Now I'll show you a bit about.", 'start': 2950.312, 'duration': 2.681}, {'end': 2957.195, 'text': "I'm now a bit about all these applications, other clients as well as this up there.", 'start': 2952.993, 'duration': 4.202}], 'summary': 'Invest in workflow log, runtime statistics, and consolidated information available from browser-based applications like powercenter and informatica for monitoring and administration.', 'duration': 29.275, 'max_score': 2927.92, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2927920.jpg'}, {'end': 3163.908, 'src': 'embed', 'start': 3130.938, 'weight': 6, 'content': [{'end': 3134.8, 'text': 'And this is the Informatica administrator console that is available.', 'start': 3130.938, 'duration': 3.862}, {'end': 3144.226, 'text': 'Okay, so we have got. this is the integration service. this is the revisiting service available and for this just a moment, it has got session expert.', 'start': 3134.82, 'duration': 9.406}, {'end': 3148.435, 'text': 'anyway. so, yeah, that that is basically the interface.', 'start': 3145.433, 'duration': 3.002}, {'end': 3154.1, 'text': 'that is a, I mean administrator interface that is available to perform this administration set of activities.', 'start': 3148.435, 'duration': 5.665}, {'end': 3163.908, 'text': 'yeah, I think everyone is muted.', 'start': 3154.1, 'duration': 9.808}], 'summary': 'The informatica administrator console includes integration and revisiting services, as well as a session expert for performing administration activities.', 'duration': 32.97, 'max_score': 3130.938, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3130938.jpg'}], 'start': 2675.234, 'title': 'Power center scaling and client tools, and informatica workflow and session management', 'summary': 'Covers scaling options in power center with a focus on partitioning, and introduces client tools like repository manager, power center designer, and workflow manager. it also discusses informatica workflow and session management, emphasizing the role of workflow monitor and the functionalities of repository manager, designer, and workflow manager in creating and managing workflows and sessions.', 'chapters': [{'end': 2862.348, 'start': 2675.234, 'title': 'Scaling options and client tools in power center', 'summary': 'Discusses scaling options in power center, focusing on partitioning to scale infrastructure, and introduces the client tools including repository manager, power center designer, and power center workflow manager.', 'duration': 187.114, 'highlights': ['Power Center provides partitioning options to scale up infrastructure, allowing for efficient processing of growing data.', 'Informatica installation includes server and client components, with the server installer installing services such as the Informatica service accessible through services.msc on Windows machines.', 'Repository manager is used for administrative tasks like deployment of workflows, creation of folders, and permissions assignment, while Power Center Designer is essential for developing Informatica mapping and ETL mapping.', 'Power Center Workflow Manager is where sessions and workflows are built, providing a platform for managing data processing tasks.']}, {'end': 3219.41, 'start': 2863.644, 'title': 'Informatica workflow and session management', 'summary': 'Discusses informatica workflow and session management, including the role of workflow monitor in monitoring job performance and the functionalities of repository manager, designer, and workflow manager in creating and managing workflows and sessions.', 'duration': 355.766, 'highlights': ['Workflow monitor allows monitoring job performance including time consumption and throughput, as well as runtime statistics and log details. Workflow monitor provides insights into job performance, including time consumption, throughput, runtime statistics, and log details, aiding in support and maintenance projects.', 'Repository manager and designer are crucial for creating folders, mappings, and sessions, as well as managing transformations and workflows. Repository manager and designer play a vital role in creating and managing folders, mappings, sessions, and transformations, essential for application administration and workflow management.', 'Workflow manager serves as the interface for building sessions and workflows, while Informatica administrator console provides an interface for performing administration activities. Workflow manager facilitates the construction of sessions and workflows, while the Informatica administrator console offers an interface for executing administration activities, enhancing workflow and session management.']}], 'duration': 544.176, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM2675234.jpg', 'highlights': ['Power Center provides partitioning options to scale up infrastructure, allowing for efficient processing of growing data.', 'Informatica installation includes server and client components, with the server installer installing services such as the Informatica service accessible through services.msc on Windows machines.', 'Repository manager is used for administrative tasks like deployment of workflows, creation of folders, and permissions assignment, while Power Center Designer is essential for developing Informatica mapping and ETL mapping.', 'Power Center Workflow Manager is where sessions and workflows are built, providing a platform for managing data processing tasks.', 'Workflow monitor allows monitoring job performance including time consumption and throughput, as well as runtime statistics and log details.', 'Repository manager and designer are crucial for creating folders, mappings, and sessions, as well as managing transformations and workflows.', 'Workflow manager serves as the interface for building sessions and workflows, while Informatica administrator console provides an interface for performing administration activities.']}, {'end': 3643.352, 'segs': [{'end': 3320.736, 'src': 'embed', 'start': 3251.662, 'weight': 0, 'content': [{'end': 3262.27, 'text': 'so yeah, as I was saying, you know now these are that power center server components, repository service and integration service.', 'start': 3251.662, 'duration': 10.608}, {'end': 3269.588, 'text': 'they are the mandatory part or mandatory server component to be present in power center.', 'start': 3262.27, 'duration': 7.318}, {'end': 3276.469, 'text': 'unless and until both of them are present you are not you will not be able to perform the ETL activity.', 'start': 3269.588, 'duration': 6.881}, {'end': 3285.051, 'text': 'yeah, then, BW service and web service hub these are optional services available from Informatica power center.', 'start': 3276.469, 'duration': 8.582}, {'end': 3290.612, 'text': 'you can configure it, but if you have only have a requirement to get connected with the system.', 'start': 3285.051, 'duration': 5.561}, {'end': 3298.217, 'text': 'so if you have option, if you have, And now, the requirement of connecting to a SAP BW system, you can use that SAP BW service,', 'start': 3290.612, 'duration': 7.605}, {'end': 3300.219, 'text': 'can create SAP BW service.', 'start': 3298.217, 'duration': 2.002}, {'end': 3307.585, 'text': 'or if you have the requirement for connecting to the web services hub I mean web services either you need to consume the data from web service,', 'start': 3300.219, 'duration': 7.366}, {'end': 3309.366, 'text': 'or you need to publish the data to web service.', 'start': 3307.585, 'duration': 1.781}, {'end': 3311.028, 'text': 'publish the data as a form of web service.', 'start': 3309.366, 'duration': 1.662}, {'end': 3314.611, 'text': 'So you can use your web service hub, that particular service.', 'start': 3311.428, 'duration': 3.183}, {'end': 3320.736, 'text': 'Now repository service is one of the major components for Informatica Power Center.', 'start': 3315.071, 'duration': 5.665}], 'summary': 'Informatica power center requires mandatory components like repository and integration services, with optional services like bw and web service hub available.', 'duration': 69.074, 'max_score': 3251.662, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3251662.jpg'}, {'end': 3518.39, 'src': 'heatmap', 'start': 3391.364, 'weight': 3, 'content': [{'end': 3396.694, 'text': 'Mandatory comment for Informatica installation is to create a two database users.', 'start': 3391.364, 'duration': 5.33}, {'end': 3403.918, 'text': 'One is for your domain repository and one is for your metadata repository or the repository in a larger sense.', 'start': 3397.314, 'duration': 6.604}, {'end': 3410.021, 'text': 'The domain database or the domain repository will contain relevant information about the domain,', 'start': 3404.698, 'duration': 5.323}, {'end': 3419.486, 'text': 'and this metadata repository or the repository database will contain that relevant information about your ETL codes, ETL sessions, ETL workflows,', 'start': 3410.021, 'duration': 9.465}, {'end': 3422.068, 'text': 'connections, the conditions.', 'start': 3419.486, 'duration': 2.582}, {'end': 3425.693, 'text': 'Everything there right?', 'start': 3424.153, 'duration': 1.54}, {'end': 3432.595, 'text': 'And then we have got the integration service, which basically facilitates the execution of sessions and workflows.', 'start': 3426.373, 'duration': 6.222}, {'end': 3438.376, 'text': 'Now we are coming into the architecture.', 'start': 3436.095, 'duration': 2.281}, {'end': 3444.657, 'text': "So I'll show you step by step what are the components that are getting introduced and how they're communicating to each other.", 'start': 3438.796, 'duration': 5.861}, {'end': 3450.378, 'text': 'So when we are installing Informatica, we have our domain created.', 'start': 3445.157, 'duration': 5.221}, {'end': 3452.278, 'text': "Now what is domain? I'll tell you.", 'start': 3450.878, 'duration': 1.4}, {'end': 3456.335, 'text': "But let us assume the domain is something, right? So what is domain? I'll tell you later.", 'start': 3452.853, 'duration': 3.482}, {'end': 3458.757, 'text': 'A domain is created right?', 'start': 3456.876, 'duration': 1.881}, {'end': 3470.225, 'text': 'When a domain is created, we have got the interfaces, like Informatica administrator, as well as this domain database, available right?', 'start': 3459.237, 'duration': 10.988}, {'end': 3474.648, 'text': 'So whenever a domain needs to be created, our domain database should also be available.', 'start': 3470.405, 'duration': 4.243}, {'end': 3478.631, 'text': 'Domain database meaning our user or the schema in our Oracle database.', 'start': 3474.708, 'duration': 3.923}, {'end': 3488.686, 'text': 'So domain is basically a fundamental administrative unit for Informatica nodes and services.', 'start': 3481.98, 'duration': 6.706}, {'end': 3493.67, 'text': 'Now here again that unknown terms nodes and services that will be explained later.', 'start': 3489.727, 'duration': 3.943}, {'end': 3500.536, 'text': 'An Informatica domain is a collection or group of nodes and services that define the Informatica platform.', 'start': 3494.19, 'duration': 6.346}, {'end': 3502.818, 'text': "So it's basically an administrative unit.", 'start': 3500.896, 'duration': 1.922}, {'end': 3511.944, 'text': 'through which we can administrator different Informatica Power Center components like nodes and services mostly.', 'start': 3504.477, 'duration': 7.467}, {'end': 3518.39, 'text': 'A Power Center domain that we create while installing Power Center is called that local domain.', 'start': 3513.105, 'duration': 5.285}], 'summary': 'Informatica installation requires creating two database users for domain and metadata repositories, which store etl codes, sessions, workflows, and connections. the integration service facilitates execution of sessions and workflows, with the domain serving as the administrative unit for informatica nodes and services.', 'duration': 47.012, 'max_score': 3391.364, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3391364.jpg'}, {'end': 3536.439, 'src': 'embed', 'start': 3489.727, 'weight': 7, 'content': [{'end': 3493.67, 'text': 'Now here again that unknown terms nodes and services that will be explained later.', 'start': 3489.727, 'duration': 3.943}, {'end': 3500.536, 'text': 'An Informatica domain is a collection or group of nodes and services that define the Informatica platform.', 'start': 3494.19, 'duration': 6.346}, {'end': 3502.818, 'text': "So it's basically an administrative unit.", 'start': 3500.896, 'duration': 1.922}, {'end': 3511.944, 'text': 'through which we can administrator different Informatica Power Center components like nodes and services mostly.', 'start': 3504.477, 'duration': 7.467}, {'end': 3518.39, 'text': 'A Power Center domain that we create while installing Power Center is called that local domain.', 'start': 3513.105, 'duration': 5.285}, {'end': 3524.876, 'text': 'And domain, this is the domain that we access when you log into Informatica Administration Console.', 'start': 3519.371, 'duration': 5.505}, {'end': 3536.439, 'text': 'Now, when you log into Informatica Administration Console, When you log into that Informatica administration console.', 'start': 3525.757, 'duration': 10.682}], 'summary': 'An informatica domain is a collection of nodes and services used to administer power center components, with a local domain created during installation.', 'duration': 46.712, 'max_score': 3489.727, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3489727.jpg'}, {'end': 3599.094, 'src': 'embed', 'start': 3575.168, 'weight': 9, 'content': [{'end': 3586.394, 'text': 'And, uh, domain configuration information is stored in a set of relational database tables which is managed with a service manager,', 'start': 3575.168, 'duration': 11.226}, {'end': 3589.095, 'text': 'a service manager that is basically a component of Informatica server.', 'start': 3586.394, 'duration': 2.701}, {'end': 3596.713, 'text': 'And that particular relational data set of tables, or the schema that is containing that particular set of tables,', 'start': 3589.81, 'duration': 6.903}, {'end': 3599.094, 'text': 'is called the domain database or the domain repositories.', 'start': 3596.713, 'duration': 2.381}], 'summary': 'Domain configuration stored in relational database tables managed by informatica server.', 'duration': 23.926, 'max_score': 3575.168, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3575168.jpg'}], 'start': 3221.471, 'title': 'Informatica power center, metadata, and domain', 'summary': 'Covers informatica power center components including the repository service, integration service, bw service, and web service hub, metadata architecture, and the informatica domain and its components such as nodes, services, and domain database details encompassing host names, port numbers, cpu usage, and user privileges.', 'chapters': [{'end': 3348.69, 'start': 3221.471, 'title': 'Informatica power center components', 'summary': 'Discusses the mandatory and optional components of informatica power center, including the repository service, integration service, bw service, and web service hub, and their relevance in performing etl activities.', 'duration': 127.219, 'highlights': ['The repository service and integration service are mandatory components of Informatica Power Center, required for performing ETL activities.', 'The BW service and web service hub are optional services available from Informatica Power Center, used for connecting to SAP BW system and consuming or publishing data to web services.', 'The repository service manages the repository, retrieving, inserting, and updating metadata into the repository database table, making it a major component for Informatica Power Center.']}, {'end': 3438.376, 'start': 3348.69, 'title': 'Informatica metadata architecture', 'summary': "Discusses informatica's reliance on metadata, the purpose of metadata in storing etl codes, sessions, and workflows, and the creation of domain and metadata repositories for informatica installation and functioning.", 'duration': 89.686, 'highlights': ['Informatica relies on metadata architecture to store ETL codes, sessions, workflows, connections, and conditions in a relational database table, known as the repository.', 'Informatica installation involves creating two database users, one for the domain repository and one for the metadata repository, containing relevant information about the domain and ETL processes.', 'The integration service in Informatica facilitates the execution of sessions and workflows.', "Informatica's metadata architecture is crucial for storing and managing ETL-related information, ensuring efficient execution of ETL processes."]}, {'end': 3643.352, 'start': 3438.796, 'title': 'Informatica domain and components', 'summary': 'Provides an overview of informatica domain, explaining its components, such as nodes and services, and the information stored in the domain database, including host names, port numbers, cpu usage, and user privileges.', 'duration': 204.556, 'highlights': ['Informatica domain is a fundamental administrative unit for Informatica nodes and services. The domain acts as an administrative unit for Informatica nodes and services, providing a platform for managing different Informatica Power Center components.', 'A Power Center domain created during installation is accessed through the Informatica Administration Console. The domain created during Power Center installation is referred to as the local domain, accessible through the Informatica Administration Console.', 'Domain configuration information is stored in a set of relational database tables, managed with a service manager, known as the domain database. The domain configuration details, including host names, port numbers, CPU usage, and user privileges, are stored in a relational database managed by the service manager, known as the domain database.']}], 'duration': 421.881, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3221471.jpg', 'highlights': ['The repository service and integration service are mandatory components of Informatica Power Center, required for performing ETL activities.', 'The BW service and web service hub are optional services available from Informatica Power Center, used for connecting to SAP BW system and consuming or publishing data to web services.', 'The repository service manages the repository, retrieving, inserting, and updating metadata into the repository database table, making it a major component for Informatica Power Center.', 'Informatica relies on metadata architecture to store ETL codes, sessions, workflows, connections, and conditions in a relational database table, known as the repository.', 'Informatica installation involves creating two database users, one for the domain repository and one for the metadata repository, containing relevant information about the domain and ETL processes.', 'The integration service in Informatica facilitates the execution of sessions and workflows.', "Informatica's metadata architecture is crucial for storing and managing ETL-related information, ensuring efficient execution of ETL processes.", 'Informatica domain is a fundamental administrative unit for Informatica nodes and services. The domain acts as an administrative unit for Informatica nodes and services, providing a platform for managing different Informatica Power Center components.', 'A Power Center domain created during installation is accessed through the Informatica Administration Console. The domain created during Power Center installation is referred to as the local domain, accessible through the Informatica Administration Console.', 'Domain configuration information is stored in a set of relational database tables, managed with a service manager, known as the domain database. The domain configuration details, including host names, port numbers, CPU usage, and user privileges, are stored in a relational database managed by the service manager, known as the domain database.']}, {'end': 4622.851, 'segs': [{'end': 3800.788, 'src': 'embed', 'start': 3761.699, 'weight': 0, 'content': [{'end': 3769.127, 'text': 'when we configure a domain with multiple gateway nodes, one node act as a master gateway node.', 'start': 3761.699, 'duration': 7.428}, {'end': 3773.591, 'text': 'so as I said, that when there will be multiple nodes available,', 'start': 3769.127, 'duration': 4.464}, {'end': 3778.917, 'text': 'so one node will be act as a master gateway node and the rest of the node will work as a worker node.', 'start': 3773.591, 'duration': 5.326}, {'end': 3789.183, 'text': 'so master gateway node with basically act as an entry point to the power center domain that we have created and if the master data node become unavailable,', 'start': 3778.917, 'duration': 10.266}, {'end': 3793.085, 'text': 'the service manager or the other gateway node create another master gateway node.', 'start': 3789.183, 'duration': 3.902}, {'end': 3800.788, 'text': 'so that is basically a part of, or the feature of, Informatica high availability solution and you will need a license for that.', 'start': 3793.085, 'duration': 7.703}], 'summary': "When configuring a domain with multiple gateway nodes, one node acts as a master gateway node. if the master data node becomes unavailable, the service manager or other gateway node creates another master gateway node, which is a feature of informatica's high availability solution requiring a license.", 'duration': 39.089, 'max_score': 3761.699, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3761699.jpg'}, {'end': 3851.523, 'src': 'embed', 'start': 3824.247, 'weight': 2, 'content': [{'end': 3830.39, 'text': "That's a term that we use mostly, which runs as a service right?", 'start': 3824.247, 'duration': 6.143}, {'end': 3839.493, 'text': 'That runs on all nodes in the domain to support the application services and manages all the domain operations.', 'start': 3831.23, 'duration': 8.263}, {'end': 3845.115, 'text': 'So the activity of service manager is to support all the application services.', 'start': 3840.089, 'duration': 5.026}, {'end': 3846.316, 'text': 'What are application services?', 'start': 3845.255, 'duration': 1.061}, {'end': 3851.523, 'text': 'Application services are this your integration service and the repository service.', 'start': 3847.037, 'duration': 4.486}], 'summary': 'Service manager supports all application services in the domain.', 'duration': 27.276, 'max_score': 3824.247, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3824247.jpg'}, {'end': 3904.741, 'src': 'embed', 'start': 3876.229, 'weight': 3, 'content': [{'end': 3886.747, 'text': 'So suppose, say, you know you are logging into a Informatica server server right, so that particular username has some set of privileges right,', 'start': 3876.229, 'duration': 10.518}, {'end': 3888.068, 'text': 'so you can only access.', 'start': 3886.747, 'duration': 1.321}, {'end': 3893.432, 'text': 'let us say that you are constrained by your privilege, that you can only access to Informatica designer only.', 'start': 3888.068, 'duration': 5.364}, {'end': 3904.741, 'text': "you can create the Informatica mapping right so that set of privileges will be validated by service manager when you log in and you'll be given access and that set of privileges stay in this domain database.", 'start': 3893.432, 'duration': 11.309}], 'summary': 'Users with specific privileges can access informatica designer to create mappings, validated by the service manager and stored in the domain database.', 'duration': 28.512, 'max_score': 3876.229, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3876229.jpg'}, {'end': 3934.563, 'src': 'embed', 'start': 3910.424, 'weight': 4, 'content': [{'end': 3916.508, 'text': 'and it will restrict you to those particular tool or set of services available to you only.', 'start': 3910.424, 'duration': 6.084}, {'end': 3923.432, 'text': 'yeah, as i said, that in informatica has the partitioning options, which is a licensed feature, but it supports parallel processing.', 'start': 3916.508, 'duration': 6.924}, {'end': 3934.563, 'text': 'we have got, you know, we can process, we can acquire the data or post the data parallelly from any sources, or we can, you know,', 'start': 3923.432, 'duration': 11.131}], 'summary': 'Informatica offers licensed partitioning options for parallel processing.', 'duration': 24.139, 'max_score': 3910.424, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3910424.jpg'}, {'end': 4003.039, 'src': 'embed', 'start': 3955.664, 'weight': 5, 'content': [{'end': 3959.125, 'text': 'that is basically the different, as I said, domain database contains.', 'start': 3955.664, 'duration': 3.461}, {'end': 3966.788, 'text': 'you know that domain related information like the host name and the port number, the users and their privileges,', 'start': 3959.125, 'duration': 7.663}, {'end': 3970.49, 'text': 'and you know some set of you know that CPU related information and those things.', 'start': 3966.788, 'duration': 3.702}, {'end': 3977.993, 'text': 'but repository is the main part of the or the heart of the ETL, of this power center ETL tool.', 'start': 3970.49, 'duration': 7.503}, {'end': 3985.184, 'text': 'repository contains everything that you are creating in designer workflow manager.', 'start': 3977.993, 'duration': 7.191}, {'end': 3993.931, 'text': 'so your transformation, your mapping, your everything, that is that you are creating, that is there in the repository power center.', 'start': 3985.184, 'duration': 8.747}, {'end': 3998.315, 'text': 'ETL tool heavily relies on the concept of metadata.', 'start': 3993.931, 'duration': 4.384}, {'end': 4003.039, 'text': 'it stores everything in a set of relational tables, right.', 'start': 3998.315, 'duration': 4.724}], 'summary': 'The repository in the etl tool stores all created components and heavily relies on metadata.', 'duration': 47.375, 'max_score': 3955.664, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3955664.jpg'}, {'end': 4089.101, 'src': 'embed', 'start': 4043.099, 'weight': 7, 'content': [{'end': 4050.684, 'text': 'coming with Informatica installation and with the domain database as well, using the native drivers, right?', 'start': 4043.099, 'duration': 7.585}, {'end': 4061.592, 'text': 'And then the integration service talks to repository service using the TCP IP protocol and administrator on the console that talks to the domain.', 'start': 4051.365, 'duration': 10.227}, {'end': 4067.095, 'text': 'it has option for HTTPS as well as HTTP as well.', 'start': 4062.634, 'duration': 4.461}, {'end': 4076.958, 'text': 'the power center client tools got introduced, so these client tools also need to communicate with the domain and the repository.', 'start': 4067.095, 'duration': 9.863}, {'end': 4081.479, 'text': 'yeah, so the communication is via TCP IP for both of them.', 'start': 4076.958, 'duration': 4.521}, {'end': 4083.519, 'text': 'now, why they need to communicate?', 'start': 4081.479, 'duration': 2.04}, {'end': 4085.7, 'text': 'because you know your privileges.', 'start': 4083.519, 'duration': 2.181}, {'end': 4089.101, 'text': 'when you are logging to a particular tool, your privilege need to be restricted.', 'start': 4085.7, 'duration': 3.401}], 'summary': 'Informatica installation uses tcp ip for communication, with options for https and http. tools communicate with domain and repository to restrict user privileges.', 'duration': 46.002, 'max_score': 4043.099, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM4043099.jpg'}, {'end': 4177.639, 'src': 'embed', 'start': 4154.721, 'weight': 10, 'content': [{'end': 4163.988, 'text': 'we have got node integration service, repository service, repository database, domain database administration console, the sources and the targets.', 'start': 4154.721, 'duration': 9.267}, {'end': 4166.25, 'text': 'And these clients?', 'start': 4164.788, 'duration': 1.462}, {'end': 4169.974, 'text': 'these clients, they also need to talk to sources as well as the targets.', 'start': 4166.25, 'duration': 3.724}, {'end': 4171.215, 'text': 'right why?', 'start': 4169.974, 'duration': 1.241}, {'end': 4177.639, 'text': 'because you will have to create the metadata of your source in your designer, and that is the reason,', 'start': 4171.215, 'duration': 6.424}], 'summary': 'Services include node integration, repository, and domain databases, with clients needing to interact with sources and targets for metadata creation.', 'duration': 22.918, 'max_score': 4154.721, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM4154720.jpg'}, {'end': 4274.304, 'src': 'heatmap', 'start': 4219.954, 'weight': 0.723, 'content': [{'end': 4224.056, 'text': 'Now, let us consider that we are creating a mapping.', 'start': 4219.954, 'duration': 4.102}, {'end': 4231.766, 'text': 'Now, this is a very simple mapping actually.', 'start': 4228.619, 'duration': 3.147}, {'end': 4235.368, 'text': 'So here we have got a source.', 'start': 4231.826, 'duration': 3.542}, {'end': 4243.092, 'text': 'This is a Oracle table, right? So now source definition should be present in the, you know, the designer in order to start the mapping.', 'start': 4236.068, 'duration': 7.024}, {'end': 4247.274, 'text': 'And now we should also specify where we are sending the data.', 'start': 4243.532, 'duration': 3.742}, {'end': 4252.716, 'text': 'So target definition should also be present now in order to import the targets right?', 'start': 4247.434, 'duration': 5.282}, {'end': 4257.118, 'text': 'So this is a target designer and we have got the option for import from database.', 'start': 4252.756, 'duration': 4.362}, {'end': 4267.18, 'text': 'So, based on this actually Informatica will import the definitions of the target, just like it has imported these two definitions.', 'start': 4257.739, 'duration': 9.441}, {'end': 4274.304, 'text': "Yeah So if you open that, don't worry, I'll show you later as well.", 'start': 4267.46, 'duration': 6.844}], 'summary': 'Creating a simple mapping with source and target definitions in informatica.', 'duration': 54.35, 'max_score': 4219.954, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM4219954.jpg'}, {'end': 4324.227, 'src': 'embed', 'start': 4294.021, 'weight': 9, 'content': [{'end': 4303.424, 'text': 'okay, so that is the reason it needs to connect to the target to get those relevant metadata related information.', 'start': 4294.021, 'duration': 9.403}, {'end': 4305.745, 'text': 'yeah, so this is the overall architecture,', 'start': 4303.424, 'duration': 2.321}, {'end': 4314.388, 'text': 'along with all those components of Informatica power center that will be present when you will be developing that ETL jobs.', 'start': 4305.745, 'duration': 8.643}, {'end': 4324.227, 'text': 'now, this particular slide will give you a bit of detail of every component mentioned just below to it,', 'start': 4314.388, 'duration': 9.839}], 'summary': 'Informatica power center connects to target for metadata; it has various etl components.', 'duration': 30.206, 'max_score': 4294.021, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM4294021.jpg'}, {'end': 4622.851, 'src': 'embed', 'start': 4596.716, 'weight': 11, 'content': [{'end': 4602.917, 'text': 'So there will be Erwin, there will be PowerDesigner, some CWM tools and there will be Hyperion Integration Manager.', 'start': 4596.716, 'duration': 6.201}, {'end': 4609.239, 'text': 'So within this Informatica even extends the metadata that is stored in the repository.', 'start': 4603.558, 'duration': 5.681}, {'end': 4616.421, 'text': 'So licensed feature metadata manager should be installed along with the installation, otherwise this feature will not be available.', 'start': 4609.339, 'duration': 7.082}, {'end': 4622.851, 'text': 'but metadata manager is not part of this particular course.', 'start': 4617.447, 'duration': 5.404}], 'summary': 'Informatica extends metadata using erwin, powerdesigner, cwm tools, and hyperion integration manager.', 'duration': 26.135, 'max_score': 4596.716, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM4596716.jpg'}], 'start': 3645.593, 'title': 'Informatica architecture', 'summary': 'Covers informatica node configuration, server and database overview, and powercenter architecture. it includes high availability features, database privileges, and communication methods.', 'chapters': [{'end': 3876.089, 'start': 3645.593, 'title': 'Informatica node configuration', 'summary': 'Discusses the configuration of nodes in an informatica domain, including the concept of gateway nodes, worker nodes, and master gateway nodes, as well as the role of service manager and the availability of high availability features based on licensing.', 'duration': 230.496, 'highlights': ['The concept of gateway nodes, worker nodes, and master gateway nodes is essential in configuring a multi-node domain in Informatica. It explains the roles and distinctions among gateway nodes, worker nodes, and master gateway nodes within a domain.', 'The availability of high availability features in Informatica is contingent upon having the requisite license. It emphasizes the requirement of a specific license to enable high availability features in Informatica.', 'The service manager plays a crucial role in supporting application services and managing domain operations. It elaborates on the function of the service manager in supporting application services and overseeing domain operations.']}, {'end': 4022.75, 'start': 3876.229, 'title': 'Informatica server and database overview', 'summary': 'Discusses the privileges and access control in informatica, the use of partitioning for parallel processing, and the difference between domain and repository databases, highlighting the key aspects such as database content and metadata storage.', 'duration': 146.521, 'highlights': ['The Informatica server validates user privileges stored in the domain database upon login, restricting access to specific tools and services.', 'Informatica supports parallel processing through partitioning, allowing for simultaneous data acquisition and transformation across different sources.', 'The domain database contains domain-related information such as host names, port numbers, user privileges, and CPU-related details, while the repository database stores metadata and logs related to sessions and operations.', 'The repository database serves as the heart of the ETL tool, containing all created components like transformations, mappings, and workflows, and heavily relies on metadata stored in relational tables.']}, {'end': 4622.851, 'start': 4022.75, 'title': 'Informatica powercenter architecture', 'summary': "Describes the communication methods and components of informatica powercenter, including the communication protocols used, the purpose of communication between components, and the architecture's data flow and metadata exchange capabilities.", 'duration': 600.101, 'highlights': ['Informatica repository service communicates with repository database using native drivers and the integration service talks to repository service using TCP IP protocol. The Informatica repository service communicates with the repository database using native drivers, and the integration service communicates with the repository service using the TCP IP protocol.', 'PowerCenter client tools communicate with the domain and the repository via TCP IP, enabling the import of source and target definitions for ETL jobs. The PowerCenter client tools communicate with the domain and the repository via TCP IP, allowing the import of source and target definitions for ETL jobs.', 'Informatica fetches metadata related information from the target database, requiring communication with the target to obtain relevant metadata. Informatica fetches metadata related information from the target database, necessitating communication with the target to obtain relevant metadata.', 'The architecture includes components such as domain, node, integration service, repository service, repository database, administration console, sources, and targets. The architecture encompasses components like domain, node, integration service, repository service, repository database, administration console, sources, and targets.', 'Metadata exchange enables the exchange of metadata information from PowerCenter repository to tools like Erwin, PowerDesigner, and Hyperion Integration Manager, requiring the installation of metadata manager. Metadata exchange allows the exchange of metadata information from the PowerCenter repository to tools like Erwin, PowerDesigner, and Hyperion Integration Manager, requiring the installation of metadata manager.']}], 'duration': 977.258, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM3645593.jpg', 'highlights': ['The concept of gateway nodes, worker nodes, and master gateway nodes is essential in configuring a multi-node domain in Informatica. It explains the roles and distinctions among gateway nodes, worker nodes, and master gateway nodes within a domain.', 'The availability of high availability features in Informatica is contingent upon having the requisite license. It emphasizes the requirement of a specific license to enable high availability features in Informatica.', 'The service manager plays a crucial role in supporting application services and managing domain operations. It elaborates on the function of the service manager in supporting application services and overseeing domain operations.', 'The Informatica server validates user privileges stored in the domain database upon login, restricting access to specific tools and services.', 'Informatica supports parallel processing through partitioning, allowing for simultaneous data acquisition and transformation across different sources.', 'The domain database contains domain-related information such as host names, port numbers, user privileges, and CPU-related details, while the repository database stores metadata and logs related to sessions and operations.', 'The repository database serves as the heart of the ETL tool, containing all created components like transformations, mappings, and workflows, and heavily relies on metadata stored in relational tables.', 'Informatica repository service communicates with repository database using native drivers and the integration service talks to repository service using TCP IP protocol. The Informatica repository service communicates with the repository database using native drivers, and the integration service communicates with the repository service using the TCP IP protocol.', 'PowerCenter client tools communicate with the domain and the repository via TCP IP, enabling the import of source and target definitions for ETL jobs. The PowerCenter client tools communicate with the domain and the repository via TCP IP, allowing the import of source and target definitions for ETL jobs.', 'Informatica fetches metadata related information from the target database, requiring communication with the target to obtain relevant metadata. Informatica fetches metadata related information from the target database, necessitating communication with the target to obtain relevant metadata.', 'The architecture includes components such as domain, node, integration service, repository service, repository database, administration console, sources, and targets. The architecture encompasses components like domain, node, integration service, repository service, repository database, administration console, sources, and targets.', 'Metadata exchange enables the exchange of metadata information from PowerCenter repository to tools like Erwin, PowerDesigner, and Hyperion Integration Manager, requiring the installation of metadata manager. Metadata exchange allows the exchange of metadata information from the PowerCenter repository to tools like Erwin, PowerDesigner, and Hyperion Integration Manager, requiring the installation of metadata manager.']}, {'end': 5377.293, 'segs': [{'end': 4708.734, 'src': 'embed', 'start': 4684.261, 'weight': 0, 'content': [{'end': 4691.085, 'text': 'Yeah, so, as I was saying, if we have high-availability feature available through our licensing,', 'start': 4684.261, 'duration': 6.824}, {'end': 4694.566, 'text': 'so there we can configure more than one gateway nodes.', 'start': 4691.085, 'duration': 3.481}, {'end': 4697.688, 'text': 'One will be master gateway node, and other will be normal.', 'start': 4695.127, 'duration': 2.561}, {'end': 4700.089, 'text': 'I mean other, will be normal gateway nodes, right?', 'start': 4697.808, 'duration': 2.281}, {'end': 4706.753, 'text': 'So one of the gateway nodes can take up the responsibility of the master gateway node.', 'start': 4700.53, 'duration': 6.223}, {'end': 4708.734, 'text': 'if that fails, okay?', 'start': 4706.753, 'duration': 1.981}], 'summary': 'High-availability feature allows configuring multiple gateway nodes, with one as master, ensuring failover.', 'duration': 24.473, 'max_score': 4684.261, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM4684261.jpg'}, {'end': 4917.401, 'src': 'embed', 'start': 4890.389, 'weight': 3, 'content': [{'end': 4896.654, 'text': 'It controls the domain, manages the services running on the domain and providing the service lookup.', 'start': 4890.389, 'duration': 6.265}, {'end': 4903.71, 'text': 'Service lookup is basically, you know, a lookup facility to look up a particular service, which service is needed for a particular set of activities.', 'start': 4897.225, 'duration': 6.485}, {'end': 4910.535, 'text': 'So domain, you know, gateway node, the gateway node, the service manager provide this activity as well as well as it provides,', 'start': 4903.73, 'duration': 6.805}, {'end': 4917.401, 'text': 'you know that less consumed node, based on which it can even distribute the job as well.', 'start': 4910.535, 'duration': 6.866}], 'summary': 'The domain controls services, provides service lookup, and distributes jobs.', 'duration': 27.012, 'max_score': 4890.389, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM4890389.jpg'}, {'end': 5078.001, 'src': 'embed', 'start': 5049.695, 'weight': 1, 'content': [{'end': 5058.341, 'text': 'So we can have different set of transformations for filtering, for ranking, for aggregating, for providing different set of expression,', 'start': 5049.695, 'duration': 8.646}, {'end': 5067.936, 'text': 'for routing the data, for the XML transformations, you know, for sequence generator.', 'start': 5058.341, 'duration': 9.595}, {'end': 5069.757, 'text': 'there are a lot of lot of transformations.', 'start': 5067.936, 'duration': 1.821}, {'end': 5078.001, 'text': 'so these transformations are the components that are already present in informatica to help you out with your uh.', 'start': 5069.757, 'duration': 8.244}], 'summary': 'Informatica offers various transformations for data processing and manipulation.', 'duration': 28.306, 'max_score': 5049.695, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM5049695.jpg'}, {'end': 5355.64, 'src': 'embed', 'start': 5329.481, 'weight': 2, 'content': [{'end': 5337.345, 'text': 'So if a certain stage is behaving wrongly, unless and until you are, you know the code is very well structured and well performed, right?', 'start': 5329.481, 'duration': 7.864}, {'end': 5344.789, 'text': 'So you may have to create, you may have to change a lot of a lot part of it, instead of creating that particular component right?', 'start': 5337.785, 'duration': 7.004}, {'end': 5346.634, 'text': 'Reusability is another factor.', 'start': 5345.393, 'duration': 1.241}, {'end': 5350.957, 'text': "So you can reuse the transformation wherever you'll need that kind of activities.", 'start': 5346.994, 'duration': 3.963}, {'end': 5355.64, 'text': "You'll get to know when we'll start activity with the transformations.", 'start': 5351.818, 'duration': 3.822}], 'summary': 'Code refactoring may be needed for better performance and reusability of components.', 'duration': 26.159, 'max_score': 5329.481, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM5329481.jpg'}], 'start': 4622.851, 'title': 'Gateway node, domain functions & component based development', 'summary': 'Covers the primary function of the gateway node for routing service requests, configuring multiple gateway nodes for high availability, core and application services, domain services, and the role of the service manager. it also discusses the usage of prebuilt components like transformations in informatica power center for assembling etl jobs, reducing development time, enabling reusability, and easing bug fixing and maintenance activities.', 'chapters': [{'end': 5024.26, 'start': 4622.851, 'title': 'Gateway node and domain functions', 'summary': 'Explores the primary function of the gateway node to route service requests and the capability to configure multiple gateway nodes for high availability, along with an overview of the core and application services, domain services, and the role of the service manager in controlling domain operations.', 'duration': 401.409, 'highlights': ['The capability to configure multiple gateway nodes for high availability is mentioned, where one node acts as the master gateway node that can take up the responsibility if it fails. When high-availability feature is available, it is possible to configure more than one gateway node, with one serving as the master gateway node and others as normal gateway nodes, offering a failover mechanism if the master gateway node fails.', 'The overview of core and application services is provided, explaining the specialized functions they offer, including repository and integration services, as well as the helper services known as core services. Core services manage and maintain the environment in which Power Center operates, while application services facilitate ETL activities and include repository and integration services, with additional support from core services such as logging, licensing, and domain services.', 'The role of service manager in controlling domain operations and providing service lookup is explained, with its responsibility to manage and control core and application services across all nodes within a domain. Service manager is responsible for controlling domain operations, managing services, providing service lookup, and controlling core and application services on all nodes within a domain, with a specific emphasis on its activities within the gateway node.']}, {'end': 5377.293, 'start': 5024.92, 'title': 'Component based development in informatica', 'summary': 'Discusses the usage of prebuilt components like transformations in informatica power center for assembling etl jobs, reducing development time, enabling reusability, and easing bug fixing and maintenance activities.', 'duration': 352.373, 'highlights': ['Informatica provides prebuilt components like transformations for filtering, ranking, aggregating, providing expressions, routing data, and XML transformations. Informatica provides various prebuilt transformations like filtering, ranking, aggregating, and XML transformations, thus enabling efficient data manipulation.', 'Power Center allows building a data flow from a source to target using different components called transformations and linking them as required. Power Center facilitates building data flows using different transformations and linking them as necessary, ensuring a structured ETL process.', 'Using prebuilt components like transformations reduces development time by avoiding the need to create functional units from scratch and allows direct reuse of existing components. The reuse of prebuilt transformations reduces the need to create functional units from scratch, thereby saving development time and effort.', 'The functional units of transformations in Power Center perform data cleansing, formatting, and validation activities, simplifying the ETL process. Transformations in Power Center perform data cleansing, formatting, and validation, contributing to an efficient ETL process.', 'Component-based development facilitates easier bug fixing and maintenance activities by isolating malfunctioning components for fixing, reducing the need to modify extensive portions of code. Component-based development simplifies bug fixing and maintenance by isolating malfunctioning components for fixing, thus reducing the need to modify extensive portions of code.']}], 'duration': 754.442, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/9tvV-lbrBPM/pics/9tvV-lbrBPM4622851.jpg', 'highlights': ['The capability to configure multiple gateway nodes for high availability is mentioned, where one node acts as the master gateway node that can take up the responsibility if it fails.', 'Informatica provides various prebuilt transformations like filtering, ranking, aggregating, and XML transformations, thus enabling efficient data manipulation.', 'Using prebuilt components like transformations reduces development time by avoiding the need to create functional units from scratch and allows direct reuse of existing components.', 'The role of service manager in controlling domain operations and providing service lookup is explained, with its responsibility to manage and control core and application services across all nodes within a domain.']}], 'highlights': ['Informatica had a revenue of 8106 million in 2012, with 5000 customers in 82 countries and direct presence in 28 countries.', 'The course offers lifetime access to class recordings and 24-7 post-class support, ensuring continuous learning and assistance.', 'The chapter covers Informatica Power Center training, including 150 slides on development and administration, repository manager, technical architecture, installation operations, command line utilities, ETL scenarios, and best practices.', "Informatica's data quality tool provides clean, high-quality data for business, including address validation for around 200 countries, with 100% match for addresses in grade A countries.", 'Informatica Power Center is highlighted as a scalable and high-performance data integration software with connectors available for various business systems and web services, providing a comprehensive solution for data integration needs.', 'Informatica 9.x consolidates data integration, data quality, and data analyst into a single platform, with services restricted by licensing.', 'The architecture of Informatica Power Center has been re-engineered for improved performance, high availability, and scalability.', 'Power Center provides partitioning options to scale up infrastructure, allowing for efficient processing of growing data.', 'The repository service and integration service are mandatory components of Informatica Power Center, required for performing ETL activities.', 'The concept of gateway nodes, worker nodes, and master gateway nodes is essential in configuring a multi-node domain in Informatica.', 'The capability to configure multiple gateway nodes for high availability is mentioned, where one node acts as the master gateway node that can take up the responsibility if it fails.', 'Informatica provides various prebuilt transformations like filtering, ranking, aggregating, and XML transformations, thus enabling efficient data manipulation.']}