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 ,  Windows Azure  (Platform). Soft
Read more

How to Write an Effective Design Document

-
Image
How to Write an Effective Design Document Why write a design document? A design document is a way for you to communicate to others what your design decisions are and why your decisions are good decisions. Don’t worry if your design is not UML compliant and don’t worry if you didn’t use a special modeling tool to create it. The biggest factor that determines if your design document is good is whether or not it clearly explains your intentions. This presents a problem, however. In order to convey design decisions, you have to consider the audience that you are writing for. A peer developer will understand why a well-crafted class abstraction is a good design, however your manager will probably not. Because your peer developers and your manager have different concepts of what makes a design good, there is a need for two design documents; one for peer developers and one for managers. Each document serves a different and equally valuable purpose as you begin your project development. I
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://encosia.co
Read more