Home | Contact Us | Sitemap
DWHlabs provides Data Warehouse education services.This web portal is very useful to the Database professionals,
Data Warehouse professionals, UNIX professionals etc.,
  About Us Advertise Support us Tell your Fren Testimonial Contact Us  
 
 
Please help us continue development of this website and it's services!
 
 

 


 
DWH CONCEPTS
   
Sponsered Links
 
 
Vs Links
4
Informatica 7.x vs 8.x
 
Ans
In Informatica 8.1 has an addition of transformations and supports different unstructured data.
Introduced:

1. sql transformation
2. java transformation
3. support unstructured data like emails, word doc, and pdfs.
4. In custom transformation we can build the transformation using java or vc++
5.Concept of flat file updation is also introduced in 8.x

Object Permissions

Effective in version 8.1.1, you can assign object permissions to users when
you add a user account, set user permissions, or edit an object.

Gateway and Logging Configuration

Effective in version 8.1, you configure the gateway node and location for
log event files on the Properties tab for the domain. Log events describe
operations and error messages for core and application services, workflows
and sessions.

Log Manager runs on the master gateway node in a domain.


We can configure the maximum size of logs for automatic purge in megabytes.
Powercenter 8.1 also provides enhancements to the Log Viewer and log event
formatting.

Unicode compliance

Effective in version 8.1, all fields in the Administration Console accept
Unicode characters. One can choose UTF-8 character set as the repository
code page to store multiple languages.

Memory and CPU Resource Usage

You may notice an increase in memory and CPU resource usage on machines
running PowerCenter Services.

Domain Configuration Database


PowerCenter stores the domain configuration in a database.

License Usage

Effective in version 8.0, the Service Manager registers license information.

High Availability

High availability is the PowerCenter option that eliminates a single point
of failure in the PowerCenter environment and provides minimal service
interruption in the event of failure. High availability provides the
following functionality:
Resilience: Resilience is the ability for services to tolerate transient
failures, such as loss of connectivity to the database or network failure

source :: orkut





 
DWH 3Colors
CERTIFICATION GUIDE
DATA DICTIONARY
ALL ARTICLES
   
DWH CONCEPTS

DWH Architecture
Types of Schema
Normalization

VS LINKS

OLAP Vs OLTP
Dimension Table Vs Fact Table
Datamart Vs Data Warehouse
Data Mining Vs Web Mining


SHARE KNOWLEDGE

Now viewers can share their information with DWHlabs , please
Click Here.
Please send your feedback
Click Here .
Tell you friend about DWHlabs
Click Here .


Data Warehouse Lab

- ETL TOOL
INFORMATICA
OTHER TOOLS

- REPORTING TOOL

BUSINESS OBJECTS
OTHER TOOLS

Database Lab

- ORACLE
SQL
PL/SQL

- DB2
OTHER TOOLS

Unix Lab

Project Lab

DWH Schools

Books Store



 
  About Us Advertise Support us Tell your Fren Testimonial Contact Us  
© 2008 DWHlabs
Privacy Policy | Terms & Conditions