Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 26 January 2014

Pushdown optimization $pushdownconfig parameter – Informatica


By on 06:11:00

Depending on the database workload, you might want to use source-side, target-side, or full pushdown optimization at different times. For example, use source-side or target-side pushdown optimization during the peak hours of the day, but use full pushdown optimization from midnight until 2 a.m. when database activity is low.

To use different pushdown optimization configurations at different times, use the $$PushdownConfig mapping parameter. The parameter lets you run a session using the different types of pushdown optimization. The settings in the $$PushdownConfig parameter override the pushdown optimization settings in the session properties.

Complete the following steps to configure the mapping parameter:

1.    Create $$PushdownConfig in the Mapping Designer.

2.    When you add the $$PushdownConfig mapping parameter in the Mapping Designer, use the following values:

Field
Value
Name
$$PushdownConfig
Type
Parameter
Datatype
String
Precision or Scale
20
Aggregation
n/a
Initial Value
None
Description
Optional

3.    When you configure the session, select $$PushdownConfig for the Pushdown Optimization attribute.

4.    Define the parameter in the parameter file




Enter one of the following values for $$PushdownConfig in the parameter file:

Value
Description
None
Integration Service processes all transformation logic for the session.
Source [Seq View Conn]
Integration Service pushes as much of the transformation logic to the source database as possible.
Target [Seq View Conn]
Integration Service pushes as much of the transformation logic to the target database as possible.
Full [Seq View Conn]
Integration Service pushes as much of the transformation logic to the source and target databases as possible. The Integration Service processes any transformation logic that it cannot push to a database.


Optionally, specify one or more of the following options:

Seq. Allows the Integration Service to create a sequence object in the database.

View. Allows the Integration Service to create a view object in the database.

Conn. Indicates that the database user of the active database has read permission on the idle database, which is required to push transformation logic to the active database.

For example, enter ‘Full View Conn’ to use full pushdown optimization, enable the creation of view objects in the active database, and indicate that the active database has read permission on the idle database.

0 comments:

Post a Comment

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)