1) Virtual Name for the Unix Machines - Starting Informatica Server
When you start the informatica server the informatica will check the ip address stored in the repository (configured in workflow manager) with the ip address of the server machine.
When we want to use virtual name - the ip address resolved in the client-workflow manager will be different from the actual fiscal ip address of the server.
To Fix : Open the file pmserver.cfg and add "ServerAddress=usp-mmsprod" and then start the server.
2)Configuring the Environment Variable for Installation
---------------------------------------------------------
a)
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:path for repository server:path for informatica/pc:usr/lib:lib
PATH=$PATH: path for repository server:path for informatica/pc:usr/lib:lib
b)
For Oracle, set NLS_LANG environment variable.
If you are unsure what the value is, use the following query:
select PARAMETER, VALUE from nls_database_parameters
where PARAMETER in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET')
Use the format NLS_LANGUAGE_NLS_TERRITORY.NLS_CHARACTERSET
E.g
NLS_LANGUAGE = AMERICAN
NLS_TERRITORY = AMERICA
NLS_CHARACTERSET = WE8ISO8859P1
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG
c)
For 32-bit oracle set LD_LIBRARY_PATH to look in ORACLE_HOME/lib32.
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH.
Or
For 64-bit oracle set LD_LIBRARY_PATH to look in ORACLE_HOME/lib32. LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
Showing posts with label Installation. Show all posts
Showing posts with label Installation. Show all posts
Friday, May 8, 2009
Tuesday, April 7, 2009
Version 8 Architecture
Informatica Version 8 architecture
Domain :-
- A collection of nodes and services
- Primary unit of administration
+ Service Manager
It stores domain users and groups in the domain configuration database and periodically synchronizes them to the PowerCenter repository.
Subscribe to alerts - notification abt node events such as failure
Administration Console :-
- It is a web based application.
Security Page
- You can manage all Domain users and groups along with roles and privileges at the Domain level
Users -
High Availability :-
+ Resilience for sources and lookup transforamtion
Resilience for Network failures or database unavailability. it attempts to reconnect for the amount of time configured for retry period in the connection object
+ Operating mode
Normal mode
Safe mode - to limit access to IntegServ during deployment or maintenance
You can also configure safe mode on failover
Integration Service :-
+ Resource Thershold - resource thershold for each node to consider or eliminate a node for the dispatch of task. Maximum CPU run queue length, Max memory % thersholds, Max processes
+ Dispatch mode - the way load balancer dispatches tasks - round robin, metric based or adaptive dispatch mode
+ Service Levels - the order in which to dispatch tasks from dispatch queue. you have to create services levels in the Admin console
Transformations
+ SQL Transformation
+ HTTP Transformation
pmcmd
- massupdate
NonVersioned repository - deploymnet groups, dynamic deployment groups
Execute permiison on deploymnet group privelage to deploy without having write permission
u still need read on the source
can have mixed version service in domain
oracle supartition support - use dynamic partitioning based on NUMBER of source partition in a session -> the infa service sets the number of partitions to the total number of supartitions at he source
PUSHDOWN Optimization :-
Subquery support
data masking
Performance Improvements
- Sorter uses less cache/ temp space
- Aggregator and Joiner are faster
- Flat file source and targets
- Repository Agent Caching
Caches the objects. By default 10000
Use it in production, where there is minimal repository changes. Otherwise it will recache everytime an object changes and might impact performance
Concurrent workflow - multiple instances of workflow
Pipeline Lookup - can lookup relational, flat, sap, jms, msmq
Get runtime information - mapping variables, session variables and workflow variables e.g mapping name, folder name
Incremental Aggregation -
updates the Btree when u run for the firsttime after the upgrade.
if the upgrade is from 7 run the session without data to update the btree
Domain
Parameters and Variables :-
Can have different sections for Service Variables, service process variables, workflow variables, session parameters, mapping parameters, and mapping variables
1) you can use workflow variables in sessions. it treats as parameter and the value does not change
2) you can use the parameters and variables in the following places
Table owner name for relational sources, table prefix for targets
Ftp file name and directory
Lookup cache file name and directory
Email task(address, subject and body)
Target pre and post session sql
pre and post session commands
call text for unconnected stored procedure
target update override
command tasks
workflow log file names
table name prefix for error logs
Performance Improvement in v8.1.1:-
+ Sorter - sorter uses more compact format which reduces the temp disk space . Sort alogorithm is also improved to reduce sort time.
+ Pushdown Optimization
Generate flat file targets by transaction. You can
transaction, you add a FileName port to the flat file target definition. When you connect the FileName port in the mapping, the Integration Service writes a target file at each commit.
Version 8.6.1
Deployment Groups
+ Non versioned repository
+ Execute Deployment Groups privelage - to deploy without having write permission
u still need read on the source
+ Post deployment validation
Partitioning
+ Oracle subpartition support
Transformations
+ Data Masking.
From PowerCenter 8, you can manage all users and groups information along with roles and privileges at the Domain level on the Security page of the Administration Console
Domain :-
- A collection of nodes and services
- Primary unit of administration
+ Service Manager
It stores domain users and groups in the domain configuration database and periodically synchronizes them to the PowerCenter repository.
Subscribe to alerts - notification abt node events such as failure
Administration Console :-
- It is a web based application.
Security Page
- You can manage all Domain users and groups along with roles and privileges at the Domain level
Users -
Domain users with the appropriate privileges can log into the following PowerCenter applications: Administration Console, PowerCenter Client tools.
Repository Object level permissions are administered using the Repository Manager and are stored in the PowerCenter repository
High Availability :-
+ Resilience for sources and lookup transforamtion
Resilience for Network failures or database unavailability. it attempts to reconnect for the amount of time configured for retry period in the connection object
+ Operating mode
Normal mode
Safe mode - to limit access to IntegServ during deployment or maintenance
You can also configure safe mode on failover
Integration Service :-
+ Resource Thershold - resource thershold for each node to consider or eliminate a node for the dispatch of task. Maximum CPU run queue length, Max memory % thersholds, Max processes
+ Dispatch mode - the way load balancer dispatches tasks - round robin, metric based or adaptive dispatch mode
+ Service Levels - the order in which to dispatch tasks from dispatch queue. you have to create services levels in the Admin console
Transformations
+ SQL Transformation
+ HTTP Transformation
pmcmd
- massupdate
NonVersioned repository - deploymnet groups, dynamic deployment groups
Execute permiison on deploymnet group privelage to deploy without having write permission
u still need read on the source
can have mixed version service in domain
oracle supartition support - use dynamic partitioning based on NUMBER of source partition in a session -> the infa service sets the number of partitions to the total number of supartitions at he source
PUSHDOWN Optimization :-
Subquery support
data masking
Performance Improvements
- Sorter uses less cache/ temp space
- Aggregator and Joiner are faster
- Flat file source and targets
- Repository Agent Caching
Caches the objects. By default 10000
| EnableRepAgentCaching : | Yes |
| RACacheCapacity | 50000 |
Use it in production, where there is minimal repository changes. Otherwise it will recache everytime an object changes and might impact performance
Concurrent workflow - multiple instances of workflow
Pipeline Lookup - can lookup relational, flat, sap, jms, msmq
Get runtime information - mapping variables, session variables and workflow variables e.g mapping name, folder name
Incremental Aggregation -
updates the Btree when u run for the firsttime after the upgrade.
if the upgrade is from 7 run the session without data to update the btree
Domain
Parameters and Variables :-
Can have different sections for Service Variables, service process variables, workflow variables, session parameters, mapping parameters, and mapping variables
1) you can use workflow variables in sessions. it treats as parameter and the value does not change
2) you can use the parameters and variables in the following places
Table owner name for relational sources, table prefix for targets
Ftp file name and directory
Lookup cache file name and directory
Email task(address, subject and body)
Target pre and post session sql
pre and post session commands
call text for unconnected stored procedure
target update override
command tasks
workflow log file names
table name prefix for error logs
Performance Improvement in v8.1.1:-
+ Sorter - sorter uses more compact format which reduces the temp disk space . Sort alogorithm is also improved to reduce sort time.
+ Pushdown Optimization
Generate flat file targets by transaction. You can
transaction, you add a FileName port to the flat file target definition. When you connect the FileName port in the mapping, the Integration Service writes a target file at each commit.
Version 8.6.1
Deployment Groups
+ Non versioned repository
+ Execute Deployment Groups privelage - to deploy without having write permission
u still need read on the source
+ Post deployment validation
Partitioning
+ Oracle subpartition support
Transformations
+ Data Masking.
From PowerCenter 8, you can manage all users and groups information along with roles and privileges at the Domain level on the Security page of the Administration Console
The Service Manager stores domain users and groups in the domain configuration database and periodically synchronizes them to the PowerCenter repository.
Domain users with the appropriate privileges can log into the following PowerCenter applications: Administration Console, PowerCenter Client tools.
Repository Object level permissions are administered using the Repository Manager and are stored in the PowerCenter repository
1. Move the files to server/infa_shared directory under the PowerCenter Services installation directory.
2. Update $PMRootDir for the Integration Service process in the Administration Console. For more information about configuring $PMRootDir, see “Creating and Configuring the Integration Service” in the PowerCenter Administrator Guide.
Subscribe to:
Posts (Atom)