Answer Posted / nikhil

Looking forward for 100% Practical Online Training on Informatica.Not Looking for ABCD as every other Institute does in India.I am not looking for 30 to 40 hours training teaching basics and making easy money. I am into Data warehousing from many years in US.I find the same basic ABCD Training everywhere in India.


Below is the content for basic training I will be providing other course content once I go through the demo.Money will be paid in 4 installments this is due to my past experiences with online trainers.

=============================
Administrator Module


Understanding Domains

Nodes

Application Services

Using Administration Console

Managing the Domain

Managing Alerts

Managing Folders

Managing Permissions

Managing Application Services

Managing the Nodes

Managing Users and Groups

Managing Privileges and Roles

Domain Privileges

Repository Services Privileges

Reporting Service Privileges

Managing Roles - Assigning Privileges and Roles to Users and Groups

Creating and Configuring the Repository Services

Managing the Repository

Creating and Configuring Integration Services

Enabling and Disabling the Integration Services

Running in Normal and Safe Mode

Configuring the Integration Services Processes

Integration Services Architecture

Creating the Reporting Services

Managing the Reporting Services

Configuring the Reporting Services

Managing License

Advanced Workflow Module


Understanding Pipeline Partitioning

Partitioning Attributes

Dynamic Partitioning

Partitioning Rules

Configuring Partitioning

Partitioning Points

Adding and Deleting Partitioning points

Partitioning Relational Sources

Partitioning File Targets

Partitioning transformations

Partitioning Types

Real Time Processing

Commit Points

Workflow Recovery

Stopping and Aborting

Error Handling

Stopping and Aborting Workflows

Concurrent Workflows

Load Balancer

Workflow Variables

Predefined Workflow Variables

User- Defined Workflow Variables

Using Worklet Variables

Assigning Variable Values in a Worklet

Parameter and variables in Sessions

Working with Session Parameters

Assigning Parameter and Variables in a Session

Parameter File

Session Caches

Incremental Aggregation

Session Log Interface

Command Reference:


Using Command Line Programs

Infacmd

Infasetup

Pmcmd

pmrep

Designer Module


Using the Designer

Configuring Designer Options

Using Toolbars

Navigating the Workspace

Designer Tasks

Viewing Mapplet and Mapplet Reports

Working with Sources

Working with Relational Sources

Working with COBOL Sources

Working with Cobol Source Files

Working with Flat Files

Importing Flat Files

Editing Flat Files Definition

Formatting Flat Files Column

Working with Targets

Importing Target Definition

Creating Target Definition from Source Definition

Creating Target Definition from Transformations

Creating Target tables

Mappings

Working with Mappings

Connecting Mapping Objects

Linking Ports

Propagating Port Attributes

Working with Targets in a Mapping

Working with Relational Targets in a Mapping

Validating a Mapping

Using Workflow Generation Wizard Mapplets

Understanding Mapplets Input and Output

Using Mapplet Designer

Using Mapplets in Mapping

Mapping Parameters and Variables

Working with User-Defined Functions

Using the Debugger

Creating Breakpoints

Configuring the Debugger

Monitoring the Debugger

Evaluating Expression

Creating Cubes and Dimensions

Using Mapping Wizard

Naming Conventions

Performance Tuning Module


Performance Tuning Overview

Bottlenecks

Using Thread Statistics

Target Bottlenecks

Source Bottlenecks

Mapping Bottlenecks

Session Bottlenecks

System Bottlenecks

Optimizing the Targets

Optimizing the Source

Optimizing the Mapping

Optimizing the Transformations

Optimizing the Sessions

Optimizing thePowerCenter Components

Optimizing the System

Using Pipeline Partitions

Performance Counters

Repository Module


Understanding the Repository

Using Repository Manager

Folders

Managing Object Permissions

Working with Versioned Objects

Exporting and Importing Objects

Copying Objects

Transformation Module


Working with Transformations

Configuring Transformations

Working with Ports

Working with Expressions

Reusable Transformations

Aggregator Transformation

Custom Transformation

Expression Transformation

External Transformation

Filter Transformation

Joiner Transformation

Java Transformation

Lookup Transformation

Lookup Caches

Normalizer Transformation

Rank Transformation

Router Transformation

Sequence Generator Transformation

Sorter Transformation

Source Qualifier Transformation

SQL Transformation

Stored Procedure Transformation

Transaction Control Transformation

Union Transformation

Update Strategy Transformation

Transformation Language Reference:


The Transformation Language

Constants

Operators

Variables

Dates

Functions

Creating Custom Function

Workflow Basics Module


Workflow Manager

Workflow Manager Options

Navigating the Workspace

Working with Repository Objects

Copying Repository Objects

Comparing Repository Objects

Workflow and Worklets

Creating a Workflow

Using Workflow Wizard

Assigning an Integration Service

Working with Worklets

Working with Links

Sessions

Creating a Session Task

Editing a Session

Pre- and Post- Session Commands

Session Configuration Objects

Tasks

Creating a Task

Configuring Tasks

Working with Command Task

Working with Decision Task

Working with Event Task

Working Timer Task

Working with Assignment Task

Sources

Configuring Sources in a Session

Working with Relational Sources

Working with Flat Sources

Targets

Configuring Targets in a Session

Working with Relational Targets

Working with File Targets

Reject Files

Validation

Validating Tasks

Validating Worklets

Validating Session

Validating Workflows

Scheduling and Running Workflows

Scheduling a Workflow

Manually Starting a Workflow

Sending Email

Working with Email Tasks

Working with Post-Session Email

Workflow Monitor

Using Workflow Monitor

Customizing Workflow Monitor Options

Working with Tasks and Workflows

Using Gantt Chart View and Task View

Workflow Monitor Details

Integration Services Properties

Workflow Run Properties

Worklet Run Properties

Session Task Run Properties

Performance Details

Session and Workflow Logs

Log Events

Log Events Window

Working with Log Files

Workflow Logs

DATAWAREHOUSING SYLLABUS

Evolution of Datawarehousing - History

The need of Datawarehousing

Why Datawarehousing

What is Datawarehousing - The Definition

Subject -Oriented

Integrated

Non - Volatile

Time Varying

Datawarehousing Architecture

Data Source Layer

Data Extraction Layer

Staging Layer

ETL Layer

Data Storage Layer

Data Logic Layer

Data Presentation Layer

Metadata Layer

System Operation Layer

Dimension table

Fact table

Additive Facts

Semi Additive Facts

Non - Additive Fact

Cumulative

SnapShot

Attribute

Hierarchy

Types of Schema

Star Schema

Snow Flake Schema

Fact Constellation Schema

Slow Changing Dimension

SCD1 - Advantages/ Disadvantages

SCD2 - Advantages/ Disadvantages

SCD3 - Advantages/ Disadvantages

OLAP and OLTP

Difference between OLAP and OLTP

Types Of OLAP

Multi-Dimentional (MOLAP)

Relational(ROLAP)

Hybrid(HOLAP)

how many max partition are created in redhat linux

2241

---

CMMI certification procedures

7418

---

Murali Raju I would also be intrested in persuing qtp certification could you send me the tutorial . My email is nikhilaram@gmailcom. Can you also let me know where i can get the certification details like fees and the center information. Thanks Nikhila.

2548

---

how we can protect the chroot /mnt/sysimage with password

2269

---

I have 2 yrs ex in informatica and i am planning to do the certification. Can you please send me all the details on mcaprasad24@gmail.com thanks

2349

---

can any one give about the COGNOS and CRYSTAL REPORTS certification details?

2480

---

Can somebody please send me the TERADATAv12 Dumps on my mail id: mushahid.qureishi@gmail.com

2010

---

i want study matterials and syllabus for hpux 11i v3 based certification (hp0-a01) for HPUX system administration.

2647

---

Where can I get LAtest qtp 2010 exam questions ?

2103

---

1. What is Active Directory? 2. What is LDAP? 3. Can you connect Active Directory to other 3rd-party Directory Services? Name a few options. 4. Where is the AD database held? What other folders are related to AD? 5. What is the SYSVOL folder? 6. Name the AD NCs and replication issues for each NC 7. What are application partitions? When do I use them 8. How do you create a new application partition 9. How do you view replication properties for AD partitions and DCs? 10. What is the Global Catalog? 11. How do you view all the GCs in the forest? 12. Why not make all DCs in a large forest as GCs? 13. Trying to look at the Schema, how can I do that? 14. What are the Support Tools? Why do I need them? 15. What is LDP? What is REPLMON? What is ADSIEDIT? What is NETDOM? What is REPADMIN? 16. What are sites? What are they used for? 17. What’s the difference between a site link’s schedule and interval? 18. What is the KCC? 19. What is the ISTG? Who has that role by default? 20. What are the requirements for installing AD on a new server? 21. What can you do to promote a server to DC if you’re in a remote location with slow WAN link? 22. How can you forcibly remove AD from a server, and what do you do later? • Can I get user passwords from the AD database? 23. What tool would I use to try to grab security related packets from the wire? 24. Name some OU design considerations. 25. What is tombstone lifetime attribute? 26. What do you do to install a new Windows 2003 DC in a Windows 2000 AD? 27. What do you do to install a new Windows 2003 R2 DC in a Windows 2003 AD? 28. How would you find all users that have not logged on since last month? 29. What are the DS* commands? 30. What’s the difference between LDIFDE and CSVDE? Usage considerations? 31. What are the FSMO roles? Who has them by default? What happens when each one fails? 32. What FSMO placement considerations do you know of? 33. I want to look at the RID allocation table for a DC. What do I do? 34. What’s the difference between transferring a FSMO role and seizing one? Which one should you NOT seize? Why? 35. How do you configure a “stand-by operation master” for any of the roles? 36. How do you backup AD? 37. How do you restore AD? 38. How do you change the DS Restore admin password? 39. Why can’t you restore a DC that was backed up 4 months ago? 40. What are GPOs? 41. What is the order in which GPOs are applied? 42. Name a few benefits of using GPMC. 43. What are the GPC and the GPT? Where can I find them? 44. What are GPO links? What special things can I do to them? 45. What can I do to prevent inheritance from above? 46. How can I override blocking of inheritance? 47. How can you determine what GPO was and was not applied for a user? Name a few ways to do that. 48. A user claims he did not receive a GPO, yet his user and computer accounts are in the right OU, and everyone else there gets the GPO. What will you look for? 49. Name a few differences in Vista GPOs 50. Name some GPO settings in the computer and user parts. 51. What are administrative templates? 52. What’s the difference between software publishing and assigning? 53. Can I deploy non-MSI software with GPO? 54. You want to standardize the desktop environments (wallpaper, My Documents, Start menu, printers etc.) on the computers in one department. How would you do that?

2789

---

How can we know the certificates are fake or not. I applied the Diploma Certificates from Bhihar State Board of Technical Education and Trainning but now i am getting some dought about this Certificates. so please tell me is their any site to know the Certificates Fake or Orginal

5906

---

How to convert PDF files into SAS datasets?

2223

---

hi i done IBM AS/400 course .....i want to certification any one can information about that and material of soft copy for that....please its urgent

2121

---

how can get electrical supervisory competency certificate in state govt.

2413

---

Is the character certificate issued by the village sarpanch or numberdar valid for central govt jobs or defence entrance exama

6666

---