This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

Informatica

/Tag:Informatica

Informatica Transformations – Introduction

By | December 6th, 2013|DWH, Informatica|

What is a Transformation? A Transformation is a repository object that generates, modifies or passes data. It is the logic to Informatica to transform the data according to the business needs. Types of Transformations Transformations are basically of two types: Active Passive Active Transformation A transformation is called as an active transformation if it allows [...]

Best Practices – Informatica

By | August 26th, 2013|DWH, Informatica|

Best Practices:  The following lists some performance considerations when building mappings.      1). Filter Expressions - try to evaluate them in a port expression: Try to create the filter (true/false) answer inside a port expression upstream. Complex filter expressions slow down the mapping.  Again, expressions/conditions operate fastest in an Expression Object with an output [...]

Parallelism and Partitioning in Data Warehouses

By | March 12th, 2013|DWH, Informatica|

Difference between Partition Parallelism and Database Partitioning Database partitioning applies to DB2 multi-node targets. When this type of partitioning is selected, the PowerCenter Server queries the DB2 system and loads partitioned data into the corresponding nodes.  How do you determine the optimal degree of partitioning/parallelism based on your hardware? Consider the mapping that will be [...]

Optimization Lookup Transformation Tips

By | March 12th, 2013|DWH, Informatica|

Lookup Transformation Optimizing Tips & Techniques  When your source is large, cache lookup table columns for those lookup tables of 500,000 rows or less. This typically improves performance by 10 to 20 percent. The rule of thumb is not to cache any table over 500,000 rows. This is only true if the standard row byte [...]

Informatica rename Repository Service

By | March 12th, 2013|DWH, Informatica|

Repository Rename Procedure on UNIX The following steps should be followed when renaming a copied repository from different environment. For example, when copying production repository to lab environment for testing purpose the repository name should be renamed and re-configured for lab environment. The following actions are to be executed with Power mart administrative privileges on [...]

How to Increase Informatica Server Performance

By | March 12th, 2013|DWH, Informatica|

Many factors can affect session performance.  Here are some points: Before doing tuning that is specific to Informatica: 1). Check hard disks on related machines. (Slow disk access on source and target databases, source and target file systems, as well as the Informatica Server and repository machines can slow session performance.) 2). Improve network speed. [...]

Advantages of Informatica

By | March 12th, 2013|DWH, Informatica|

Informatica can communicate with all major data sources (Mainframe/RDBMS/Flat Files/XML/VSM/SAP etc) It can move and transform data between all these data sources effectively. .It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement only.  It can throttle the transactions (do [...]

Extraction, Transformation, and Load ( ETL) Issues and Approaches

By | March 12th, 2013|DWH, Informatica|

Introduction  This Article is created to understand the ETL architecture of tool and accordingly identify the errors occurred during job run and rectify the issue. It will help the person working in support environment to easily get the cause of issue. It is designed to understand the issues and correlate them with the different components [...]

Informatica Tips and Tricks

By | March 12th, 2013|DWH, Informatica|

Points to Remember 1). Mapping level generic information Relational data sources: Minimize the connections to sources, targets and informatica server to improve session performance. Moving target database into server system may improve session performance.   If flat files are used as source, store the flat files on a machine that consists of informatica server. Fetching the [...]

Installing and Configuring the Informatica Server on UNIX / Linux

By | March 12th, 2013|DWH, Informatica|

Before you install the informatica Server on UNIX, set the following PATHS:  Ensure that the PATH environment variable has the current working directory(or .) included in it. Set the library path to the absolute directory path (or .) where the Informatica Server is to be installed for the following operating systems:  Operating System                  Library Path  [...]