kvt, Author at Explore Informatica

Stored Procedure transformation in Informatica

Stored Procedure A stored procedure is a precompiled collection of Transact-SQL, PL-SQL or other database procedural statements and optional flow control statements, similar to an executable script. Stored procedures are… Continue reading Stored Procedure transformation in Informatica

SQL Override in Informatica

We have an option to customize the default query provided by the transformations and enter custom SQL query by using SQL override. The most common transformations which support the SQL… Continue reading SQL Override in Informatica

Solution – Create Retail Datamart using Informatica PowerCenter

Certification Project – Create Retail Datamart using Informatica PowerCenter Problem Statement. The purpose of this solution is to explain how to create a retail data warehouse / Datamart using PowerCenter.… Continue reading Solution – Create Retail Datamart using Informatica PowerCenter

Performance Tuning – Aggregator Transformations

Aggregator transformations often slow performance because they must group data before processing it. Aggregator transformations need additional memory to hold intermediate group results. Use the following guidelines to optimize the… Continue reading Performance Tuning – Aggregator Transformations

Informatica certification – Commit Points

What is source based commit? Ans:- The Integration Service commits data to the target based on the number of rows from some active sources in a target load order group.… Continue reading Informatica certification – Commit Points

Source Based Commits

The Integration Service commits data to the target based on the number of rows from some active sources in a target load order group. When the Integration Service runs… Continue reading Source Based Commits

Performance Tuning – Target Bottlenecks

The most common performance bottleneck occurs when the Integration Service writes to a target database. Small checkpoint intervals, small database network packet sizes, or problems during heavy loading operations can… Continue reading Performance Tuning – Target Bottlenecks

Informatica certification – Rank Transformation

How many Ranks ports are allowed in a Rank Transformation? Ans:- Only ONE. What is RANKINDEX? Ans:- It is an output port to which the integration service store the ranking position for… Continue reading Informatica certification – Rank Transformation

How to start a workflow using pmcmd

PowerCenter provides a number of command line programs that you call from your application to manage the Integration Service and Repository Service. What is pmcmd? pmcmd is a command line… Continue reading How to start a workflow using pmcmd

Create Retail Datamart using Informatica PowerCenter

Certification Project – Create Retail Datamart using Informatica PowerCenter Problem Statement. The purpose of this solution is to explain how to create a retail data warehouse / Datamart using PowerCenter.… Continue reading Create Retail Datamart using Informatica PowerCenter

How to create Repository Folder

Repository Folders Folders provide a way to organize and store metadata in the repository, including mappings, schemas, and sessions. Folders help you logically organize the repository. A folder consist of… Continue reading How to create Repository Folder

MD5 (Message-Digest algorithm 5) In Informatica MD5 is a one-way cryptographic hash function in informatica which is used to verify the data integrity. This function uses Message-Digest algorithm 5 (MD5) to… Continue reading MD5 (Message-Digest algorithm 5) In Informatica

How to Convert Julian to Gregorian date in Informatica

How to Convert Julian date to Gregorian date in Informatica Dates in the Julian calendar are called Julian dates which are not supported in Informatica. We need to convert the… Continue reading How to Convert Julian to Gregorian date in Informatica

Author: kvt