Informatica Power center

[vc_row full_width=”stretch_row” css=”.vc_custom_1559286923229{background-color: #f6f6f7 !important;}”][vc_column width=”1/2″][vc_tta_accordion color=”peacoc” active_section=”1″][vc_tta_section title=”Informatica PowerCenter 10 – An Overview” tab_id=”1559286383409-ab730398-6c03″][vc_column_text]

Learning Objectives: In this module of Informatica Training, we will talk about the different Informatica Products available along with understanding the overview of Informatica PowerCenter Product, Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows, and Workflow Monitor. We will also discuss the installation of Informatica in this module.
Topics:
  • Informatica & Informatica Product Suite
  • Informatica PowerCenter as ETL Tool
  • Informatica PowerCenter Architecture
  • Component-based development techniques

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Data Integration and Data Warehousing Fundamentals” tab_id=”1559286522681-3bf94e12-e7b7″][vc_column_text]

Learning Objectives: In this module of Informatica Certification Training, we will discuss different Data Integration Concepts. You will be introduced to the concepts – Data Profiling, Data Quality Management, ETL and ETL architecture, and Data Warehousing.
Topics:
  • Data Integration Concepts
  • Data Profile and Data Quality Management
  • ETL and ETL architecture
  • Brief on Data Warehousing

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Informatica PowerCenter Transformations” tab_id=”1561382593569-b1979b66-b066″][vc_column_text]

Learning Objectives: In this module of Informatica Certification Training, you will learn about different development units of PowerCenter and how they can be used to create a simple mapping and transformations.
Topics:
  • Visualize PowerCenter client tools
  • Data Flow
  • Create & execute mapping
  • Transformations & their usage

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Informatica PowerCenter Tasks & Workflows” tab_id=”1561382595833-dd54d407-26c0″][vc_column_text]

Learning Objectives: In this module of Informatica Certification Training, you will learn about development units of Informatica PowerCenter (workflow manager & monitor) and how are they are used to create different tasks and workflow.
Topics:
  • PowerCenter Workflow Manager
  • Flow within a Workflow
  • Reusability & Scheduling in Workflow Manager
  • Components of Workflow Monitor
  • Workflow Task and job handling

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Advanced Transformations, Techniques & Reusability Features” tab_id=”1561382597303-5168678c-55b9″][vc_column_text]

Learning Objectives: Through this module of Informatica Certification Training, you will learn about Advanced Transformation techniques which will equip you to deal with advanced concepts of PowerCenter transformations like Java, XML etc. We will also discuss various Error Handling, Transaction Processing & Reusability features available in Informatica.
Topics:
  • Advanced transformations (Java, SQL, Normalizer)
  • XML File Processing & Transaction Processing
  • Error handling features
  • Cleaning the data (Advanced Functions, Regular Expressions)
  • Reusability features

[/vc_column_text][/vc_tta_section][vc_tta_section title=”ETL Scenarios using Informatica” tab_id=”1561382598718-1fee5a6b-29dd”][vc_column_text]

Learning Objectives: In this module of Informatica Training, we will discuss advanced ETL scenarios using Informatica. You will be introduced to the concepts – Error Handling, Partitioning, PushDown Optimization, Incremental Aggregation, Constraint Based Loading, Target Load Order Group, CDC (Change Data Capture) etc. We will also discuss creating Data Warehouses related processes like SCD, Fact and Dimension Loading.
Topics:
  • Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
  • Advanced techniques – Flat File, XML File
  • Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)

[/vc_column_text][/vc_tta_section][vc_tta_section title=”What do you mean by Enterprise Data Warehousing?” tab_id=”1584632655275-274a903c-9103″][vc_column_text]

When the organization data is created at a single point of access it is called as enterprise data warehousing. Data can be provided with a global view to the server via a single source store. One can do periodic analysis on that same source. It gives better results but however the time required is high.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”What the difference is between a database, a data warehouse and a data mart?” tab_id=”1584632655973-7b33cb68-7061″][vc_column_text]

Database includes a set of sensibly affiliated data which is normally small in size as compared to data warehouse. While in data warehouse there are assortments of all sorts of data and data is taken out only according to the customer’s needs. On the other hand datamart is also a set of data which is designed to cater the needs of different domains. For instance an organization having different chunk of data for its different departments i.e. sales, finance, marketing etc.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is meant by a domain?” tab_id=”1584632656910-37f200ed-9392″][vc_column_text]

When all related relationships and nodes are covered by a sole organizational point, its called domain. Through this data management can be improved.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is the difference between a repository server and a powerhouse?” tab_id=”1584632657542-4393d394-77f3″][vc_column_text]

Repository server controls the complete repository which includes tables, charts, and various procedures etc. Its main function is to assure the repository integrity and consistency. While a powerhouse server governs the implementation of various processes among the factors of server’s database repository.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”How many repositories can be created in informatica?” tab_id=”1584632658377-c8b31a67-bca8″][vc_column_text]

There can be any number of repositories in informatica but eventually it depends on number of ports.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is the benefit of partitioning a session?” tab_id=”1584632660087-5c3f3826-54c8″][vc_column_text]

Partitioning a session means solo implementation sequences within the session. It’s main purpose is to improve server’s operation and efficiency. Other transformations including extractions and other outputs of single partitions are carried out in parallel.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”How are indexes created after completing the load process?” tab_id=”1584632660734-0d4c8269-7288″][vc_column_text]

For the purpose of creating indexes after the load process, command tasks at session level can be used. Index creating scripts can be brought in line with the session’s workflow or the post session implementation sequence. Moreover this type of index creation cannot be controlled after the load process at transformation level.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Explain sessions. Explain how batches are used to combine executions?” tab_id=”1584632661566-a8d9905c-3a91″][vc_column_text]

A teaching set that needs to be implemented to convert data from a source to a target is called a session. Session can be carried out using the session’s manager or pmcmd command. Batch execution can be used to combine sessions executions either in serial manner or in a parallel. Batches can have different sessions carrying forward in a parallel or serial manner.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”How many number of sessions can one group in batches?” tab_id=”1584632662309-7866548b-6a04″][vc_column_text]

One can group any number of sessions but it would be easier for migration if the number of sessions are lesser in a batch.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Explain the difference between mapping parameter and mapping variable?” tab_id=”1584632663040-8d70f00c-d462″][vc_column_text]

When values change during the session’s execution it’s called a mapping variable. Upon completion the Informatica server stores the end value of a variable and is reused when session restarts. Moreover those values that do not change during the sessions execution are called mapping parameters. Mapping procedure explains mapping parameters and their usage. Values are allocated to these parameters before starting the session.

[/vc_column_text][/vc_tta_section][/vc_tta_accordion][/vc_column][vc_column width=”1/2″][vc_tta_accordion color=”peacoc” active_section=”1″][vc_tta_section title=”Service & Support of Informatica PowerCenter Environment” tab_id=”1561382561432-7f73ef2a-cc67″][vc_column_text]

Learning Objectives: In this module of Informatica Training, you will understand the features provided by Informatica to debug, troubleshoot & handle error to understand the inner workings and responsibilities of the operational role. Various PowerCenter recovery options and for tasks and workflows will be discussed along with the recommended best practices to the operations process.
Topics:
  • PowerCenter Error
  • Basic troubleshooting methodology
  • Debugger
  • Workflow and Session logs to diagnose errors
  • Connection Errors & Network errors
  • Recovery scenarios & mechanisms
  • Configure workflow & sessions for recovery
  • High Availability
  • PowerCenter Environment

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Performance Tuning, Design Principles & Caches” tab_id=”1561382561455-654071d3-eb53″][vc_column_text]

Learning Objectives: This module of Informatica Certification Training, highlights the performance aspects of Informatica PowerCenter components and the efficient use of them. We will also discuss about the best practices suggested by Informatica for optimum performance of your ETL process.
 
Topics:
  • Performance Tuning Methodology
  • Mapping design tips & tricks
  • Caching & Memory Optimization
  • Partition & Pushdown Optimization
  • Design Principles & Best Practices

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Informatica PowerCenter Repository Management” tab_id=”1561382611424-56181e07-6453″][vc_column_text]

Learning Objectives: This module of Informatica Training will introduce you to the usage and components of PowerCenter repository manager. You will also learn to migrate and manage the repository effectively.
 Topics:
  • Repository Manager tool (functionalities, create and delete, migrate components)
  • PowerCenter Repository Maintenance

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Informatica Administration & Security” tab_id=”1561382613753-7c9c9136-4ca1″][vc_column_text]

Learning Objectives: This module of Informatica Certification Training, will give you an overview of the PowerCenter administration console, recognize and explain integration and repository service properties. We will also discuss about the command line utilities and use them to manage the domain and repository, start and control workflows.
Topics:
  • Features of PowerCenter 10
  • Overview of the PowerCenter Administration Console
  • Integration and repository service properties
  • Services in the Administration Console (services, handle locks)
  • Users and groups

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Command Line Utilities” tab_id=”1561382614729-6b63842b-62b1″][vc_column_text]

Learning Objectives: This module of Informatica Certification Course deals with command line part of Informatica PowerCenter. You will learn to automate the tasks from the command line as well.
Topics:
  • Infacmd, infasetup, pmcmd, pmrep
  • Automate tasks via command-line programs

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Informatica 10 – Technical Architecture” tab_id=”1561382615672-42dd66a8-6425″][vc_column_text]

Learning Objectives: This module of Informatica Certification Training will give you the detailed coverage of the architectural aspects of Informatica as a whole and PowerCenter in particular.
Topics:
  • Informatica 10 Architecture
  • Application services
  • Buffer memory
  • Connectivity among the tolls
  • Connection Pooling

[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is complex mapping?” tab_id=”1584632664184-3e3e54bb-c0ef”][vc_column_text]Following are the features of complex mapping.

  • Difficult requirements
  • Many numbers of transformations
  • Complex business logic

[/vc_column_text][/vc_tta_section][vc_tta_section title=”How can one identify whether mapping is correct or not without connecting session?” tab_id=”1584632664806-773550c4-8425″][vc_column_text]

One can find whether the session is correct or not without connecting the session is with the help of debugging option.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Can one use mapping parameter or variables created in one mapping into any other reusable transformation?” tab_id=”1584632665418-489bcd61-b688″][vc_column_text]

Yes, One can do because reusable transformation does not contain any mapplet or mapping.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Explain the use of aggregator cache file?” tab_id=”1584632666294-05e65a63-a2cb”][vc_column_text]

Aggregator transformations are handled in chunks of instructions during each run. It stores transitional values which are found in local buffer memory. Aggregators provides extra cache files for storing the transformation values if extra memory is required.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”Briefly describe lookup transformation?” tab_id=”1584632667000-fd528f67-4d83″][vc_column_text]

Lookup transformations are those transformations which have admission right to RDBMS based data set. The server makes the access faster by using the lookup tables to look at explicit table data or the database. Concluding data is achieved by matching the look up condition for all look up ports delivered during transformations.

[/vc_column_text][/vc_tta_section][vc_tta_section title=” What does role playing dimension mean?” tab_id=”1584632667782-014eb319-c72e”][vc_column_text]

The dimensions that are utilized for playing diversified roles while remaining in the same database domain are called role playing dimensions.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”How can repository reports be accessed without SQL or other transformations?” tab_id=”1584632668479-65e2c712-70ce”][vc_column_text]Repositoryreports are established by metadata reporter. There is no need of SQL or other transformation since it is a web app.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”What are the types of metadata that stores in repository?” tab_id=”1584632669199-eaf44653-f7fa”][vc_column_text]

The types of metadata includes Source definition, Target definition, Mappings, Mapplet, Transformations.

[/vc_column_text][/vc_tta_section][vc_tta_section title=” Explain the code page compatibility?” tab_id=”1584632674306-dcaba71a-d17f”][vc_column_text]

When data moves from one code page to another provided that both code pages have the same character sets then data loss cannot occur. All the characteristics of source page must be available in the target page. Moreover if all the characters of source page are not present in the target page then it would be a subset and data loss will definitely occur during transformation due the fact the two code pages are not compatible.

[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is the difference between a connected look up and unconnected look up?” tab_id=”1584632675089-efae78dc-3949″][vc_column_text]

When the inputs are taken directly from other transformations in the pipeline it is called connected lookup. While unconnected lookup doesn’t take inputs directly from other transformations, but it can be used in any transformations and can be raised as a function using LKP expression. So it can be said that an unconnected lookup can be called multiple times in mapping.

[/vc_column_text][/vc_tta_section][/vc_tta_accordion][/vc_column][/vc_row]

WhatsApp us