Informatica Online training
Pin It

Informatica Online training

Informatica online training, Globus provides Informatica training online with real time experienced consultants. Globus also provides certification oriented Informatica online training.

Informatica Online Training Overview:

Informatica9 Architecture Informatica Online training

Informatica Online Training

Highlights in our Informatica Online  training :

Every faculty has Real Time experiance .Trained Resources placed in countries like Australia, USA, UK, JAPAN, SWEDEN etc.Any critical issues faced by resource resolved using Teamviewer, webex.Supporting the resource with Top 100 Interview questions.Resume built in best corporate standards according to the job description.We will market the resume for top technolgy countries.After each week a status exam is conducted.offline online trainings are conducted everyday.Weekend trainings for job goers.flexible timings in accordance with the resource comfortability.If version related to any Tool is upgraded. We will send the upgraded information via email.we will develop the Aquintance with Production,development and testing environments.Real time scenarios covered accross Software Development Life Cycle.for every 10 hours One hour catered to resolve the doubts.Explaining bugs and critical issues and development activities 24*7 technical supports sevices.

[button link=”https://www.dropbox.com/s/rtkim8g26qellxy/Informatica.docx” style=”download” color=”blue” border=”blue” text=”light” window=”yes”]Content Download[/button]

Informatica Online training Course content:

1. Power Center Components 
a) Designer
b) Repository Manager
c) Workflow Manager
d) Workflow Monitor
2. Informatica Concepts and Overview
a) Informatica Architecture.
b) Source Qualifier
c) Target Designer
d) Transformations
e) Mappings
f) Mapplets
g) Sessions
h) Tasks
3. Sources 
a) Working with relational Sources
b) Working with Flat Files
4. Targets 
a) Working with Relational Targets
b) Working with Flat file Targets
5. Transformations 
a) Expression Transformation
b) Lookup Transformation
c) Sequence Generator Transformation
d) Filter Transformation
e) Joiner Transformation
f) Sorter Transformation
g) Procedural Transformation
h) Router Transformation
i) Aggregator Transformation
j) Update Strategy Transformation
k) Union Transformation
L) Rank Transformation
M) Transaction Control Transformation
N) Normalizer Transformation
O) Source Qualifier Transformation
P) Stored Procedure Transformation
Q) XML Source Qualifier Transformation
R) Debugging Mappings
6. ADVANCED INFORMATICA CONCEPTS
a). Unconnected lookup Transformation
b). Mapplet
d). Defining Reusable Transformations.
e). Tasks And Types of Tasks.
f). Worklet
g). Scheduling Work flow
h). Target Load Plan
i). Types of Batch Processing
j). Link conditions
k). Mapping Parameters
m). Mapping Variables
n). Defining Session Parameters
o). PMCMD Utility
p). TYPES Of LookUp Caches.
a) Static LookUp Cache
b) Dynamic LookUp Cache
c) Perisistance lookup Cache
d) Shared LookUp Cache
7. Task Types:
1 Session
2 Command
3 EMAIL
4 Timer
5 Event Wait
6 Event Raise
7 Decision
8 Assignment
9 Control
10 Worklet
and basics of datawarehousing concepts

Informatica Online Training Faqs:

    1. What is data Modeling?
        Data Modeling is representing the real world set of data structures or entities and their relationship in their of data models, required for a database. Data Modeling consists of various types like :
        Conceptual data modeling
        Logical data modeling
        Physical data modeling
        Enterprise data modeling
        Relation data modeling
        Dimensional data modeling.
    2. What is Surrogate key?
        Surrogate key is a substitution for the natural primary key. It is just a unique identifier or number of each row that can be used for the primary key to the table.
    3. What is Data Mining?
        A Data Mining is the process of analyzing data from different perpectives and summarizing it into useful information.
    4. What is Operational Data Store?
        A ODS is an operational data store which comes as a second layer in a datawarehouse architecture. It has got the characteristics of both OLTP and DSS systems.
    5. What is the Difference between OLTP and OLAP?
        OLTP is nothing but Online Transaction Processing which contains a normalized tables.
        But OLAP(Online Analytical Programming) contains the history of OLTP data which is non-volatile acts as a Decisions Support System.
    6. How many types of dimensions are available in Informatica?
        There are three types of dimensions available are :
        Junk dimension
        Degenerative Dimension
        Conformed Dimension
    7. What is Difference between ER Modeling and Dimensional Modeling?
        ER Modeling is used for normalizing the OLTP database design.
        Dimensional modeling is used for de-normalizing the ROLAP / MOLAP design.
    8. What is the maplet?
        Maplet is a set of transformations that you build in the maplet designer and you can use in multiple mappings.
    9. What is Operational Data Store?
        A ODS is an operational data store which comes as a second layer in a data warehouse architecture. It has got the characteristics of both OLTP and DSS systems.
    10. What is the Difference between OLTP and OLAP?
        OLTP is nothing but Online Transaction Processing which contains a normalized tables.
        But OLAP(Online Analytical Programming) contains the history of OLTP data which is non-volatile acts as a Decisions Support System.
 

Informatica Online Training and Oracle interview questions

Can you copy the session to a different folder or repository?

Yes. By using copy session wizard, you can copy a session in a different folder or repository.

What is a command that used to run a batch?

pmcmd is used to start a batch.

What are the types of mapping in Getting Started Wizard?

Simple Pass through mapping

Slowly growing target mapping

What are the different types of Type2 slowly changing dimensions?

There are three types of slowly changing dimensions

SCD with versioning

SCD with flags

SCD with Date

What are the different threads in DTM process?

Master thread

Mapping thread

Reader thread

Writer thread

Pre and post session threads

What are the active and passive transformations?

An active transformation can change the number of rows that pass through it.

A passive transformation does not change the number of rows that pass through it.

What are the scheduling options to run a session?

Different options of scheduling are

Run only on demand: Informatica server runs the session only when user starts session explicitly

Run once: Informatica server runs the session only once at a specified date and time.

Run every: Informatica server runs the session at regular intervals as you configured.

Customized repeat: Informatica server runs the session at the date and time specified in the repeat dialog box.

How can we store previous session logs?

Just run the session in time stamp mode then automatically session log will not overwrite current session log.

What is the difference between Mapping and Mapplet?

Mapping is the collection of Source Definition, Target Definition, Transformation(s) and/or Mapplet.

Mapplet is a set of reusable transformations for applying samebusiness logic.

What is the use of Repository Manager?

Repository Manager is used to manage folders, view Source/Target dependencies, Mapping Dependencies, adding and removing repositories, Versioning etc.

What are the various Tasks in Informatica Workflow Manager?

The various Tasks in Informatica are

Assignment Task

Command Task

Control Task

Decision Task

E-mail Task

Event Raise Task

Event Wait Task

Session Task

Timer Task

Link Task

What is the use of Source Analyzer?

Source Analyzer is used to create source definition.

What is the use of Target Designer?

Target Designer is used to create Target Definition.

What is Target Designer called prior to Informatica 8.6?

Warehouse Designer

Can we use Reusable Sequence Generator transformation in Mapplet?

No

Why Cache? Explain with an example?

If there are x lot number of records with y number of columns from source data and we need to extract z number of columns only (very less) then the cache stores those columns for respective records in the $PMCACHEDIR of Informatica Server so that we don’t need to extract each record from database and load into Informatica. Doing this increases the performance of the system. 

What is the use of Shared Object?

It is easier to explain this using an example.

Suppose there is an object which is used by many users in the company.

If the object undergoes a change, this change has to be updated to each and every user. Instead, if the object is made as shared, then the update has to be done to the object and all other users get the update. 

What is Dual table?

Dual table is a table that is created by oracle along with data dictionary. It gives output of exactly one column name dummy and one record ‘x’.

Select * from Dual;

———–

DUMMY

X

C

Incoming Search Term for Informatica Online Training:

informatica online training free

informatica online training videos

informatica training

cognos online training