Training: Informatica 9.X

-
Training: Informatica 9.X
5 days
Prerequisites:
  • Working knowledge of SQL, especially functions, joins, sub queries etc.
  • Knowledge of PL/SQL is also recommended, but not mandatory
  • Some knowledge in ETL, and Business Intelligence, Data Warehousing Concepts.
(It Is mandatory to accomplish the training prerequisite conditions before nominating for the session)
Course Outline:
Introduction to DWH
Introduction to Informatica
Informatica Tools
Introduction  to Power center
Introduction to Power Exchange
Introduction to IDQ
Introduction to MDM Informatica Architecture Informatica Power Center  9.5
Informatica Components
Designer
Workflow manager
Workflow monitor
Repository Manager
Admin console
Informatica Designer
Introduction to designer
Logon to designer
Defining Sources
• Database as a source
Flat Files as a source
        •   XML Files  as a source
Defining Targets
 Database         as a target
Flat Files         as a target
XML as a Target
Designer Tools
•         Source Analyzer
•         Target Designer
•         Transformation Developer
•         Mapplet Designer
Workflow manager Tools
Task Developer
Worklet
 Workflow Designer
Session properties
Informatica Workflow Monitor Log Details and Debugging
Types of Transformations
  • Active Transformations
  • Passive Transformations
  • Connected    Transformations
  • UnConnected  Transformations List of Transformations

List Of Transformation
1.     Source Qualifier           Transformation
2.      Filter                            Transformation
3.      Sorter                          Transformation
4.      Expression                   Transformation
5.      Aggregator                  Transformation
6.      Router                         Transformation
7.      Union                          Transformation
8.      Rank                            Transformation
9.      Sequence Generator    Transformation
10.  Joiner                            Transformation
11.  Stored procedure         Transformation
12.  Normalize                    Transformation
13.  XML source qualifier Transformation
14.  Transaction Control    Transformation
15.  SQL                            Transformation
16.  Look up                       Transformation
17. strategy         

SlowlyChanging Dimension
Manual and Wizard
SCD1
SCD2
          Version
          Date
          Flag
SCD3
Advanced Topic:
Transformation Developer
Mapplet
Mapplet advantage/ restrictions
Worklet
Tasks
Reusable task
           Session
          Command
           Email
  Non- Reusable Task
           Timer
            Event wait
            Event raise
            Decision
Link Conditions( to execute second session if 1st succeeds)
Mapping Parameter
Variables
Local                Variables
Mapping          Variables
Session            Variables
Workflow        Variables
Email               Variables
Built-In Variables (System information,$$$sessionstarttime) Connection       Variables ($$RDBMSconn1)

SETVARIABLE
SETCOUNTVARIABLE
SETMAXVARIABLE
SETMINVARIABLE

File List/Indirect Method(to load multiple files) Scheduling informatica workflow
PMCMD commands to run workflow Incremental aggregation
Pushdown Optimization
Target Load plan/ Stored procedure load plan Constraint based load ordering
Test load plan
Collect performance data Debugging Mapping Tracing levels
Bulk Loading/Normal Loading External loaders
Oracle SQL Loader (any one will be covered) Teradata Fast load
Informatica BDM /Introduction to Informatica Administration J
Overview for Certification

Comments

Post a Comment

Popular posts from this blog

Cloud Computing in simple

-
Cloud Computing =   Infrastructure as a Service (IaaS) + Platform as a Service (PaaS) + Software as a Service (SaaS) Cloud computing, also known as Cloud Technology, Cloud Applications or Cloud-based services. Cloud Computing is the practice of using a network of remote servers hosted on the internet to store, manage and process data, rather than a local server or a personal computer. Examples of cloud-based services include customer self-scheduling, data storage, online payment, and accounting software Different Type of Clouds Infrastructure as a Service (IaaS)  – Allows users with the services like Virtual servers, Virtual storage, Physical Database, Virtual Network, Physical Network. E.g. Google Storage ,  IBM Cloud Computing ,  Nimbus Platform as a Service (PaaS)  – Provides computational resources via a platform upon which applications and services can be developed and hosted. E.g. Databases, Data Stores,  Force.com ,  Google App Engine ,...
Read more

Bookmark

-
Good Blog about Architecture & design Patterns:   http://martinfowler.com/bliki/ http://www.sharepoint-videos.com/ http://go.cloudshare.com/Linkedin_ProPlus_SharePoint.html A Technical Q/A site: http://www.bookmarkresource.com http://blog.krisvandermast.­ com/ASPNET20PageLifeCycle.aspx http://blogs.vertigosoftware.­ com/shannonf/archive/2005/08/­ 07/1355.aspx http://john-sheehan.com/blog/­ net-cheat-sheets/ http://www.eggheadcafe.com/­ articles/20051227.asp http://duartes.org/gustavo/­ articles/Asp.net-Runtime-­ Cheat-Sheet-HttpRequest-­ HttpRuntime.aspx http://www.addedbytes.com/­ cheat-sheets/javascript-cheat- ­sheet/ http://www.antsmagazine.com/­ 2009/04/100-useful-cheat-­ sheets-for-web-designers-­ developers/ Nice link abt .Net 3.5: http://www.simple-talk.com/ dotnet/.net-framework/.net-3. 5-language-enhancements/ nice articles about JQuery. http://encosia.com/2008/05/29/ using-jquery-to-directly-call- aspnet-ajax-page-methods/ http://encosi...
Read more

How to manage expectations

-
  How to manage expectations Selecting transcript lines in this section will navigate to timestamp in the video - You're probably juggling multiple projects already.  And if you're like, most of us,  your boss keeps throwing new ones at you.  How can you keep up and do a good job  and manage your supervisor's expectations?  As with many things in life,  the majority of problems can be avoided  with a detailed conversation upstream,  Well before any actual deadlines.  The first step is making a comprehensive list  of the projects you're working on,  and rank ordering them,  based on your understanding of priorities.  You then want to set up a meeting with your boss,  where you can confer and ask if your understanding  of their relative importance matches hers.  The last thing you want to do is waste time,  pushing hard on the 10th priority  when number one is languishing.  You have limited...
Read more