Author: kvt

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 used to automate tasks that are too complicated for standard SQL statements. Stored procedures are stored and run within the database. The stored procedure must… Continue reading Stored Procedure transformation​ 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. Description: Transaction and master data from OLTP (online transaction processing) systems is loaded into the data warehouse as Fact tables and Dimension tables respectively. In… 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 performance of an Aggregator transformation: Group by simple columns. Use sorted input. Use incremental aggregation. Filter data before you aggregate it. Limit port connections. Grouping… 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. What is One-to-One  mapping? Ans:- One-to-one mapping is a mapping that moves data from a Source Qualifier, XML Source Qualifier, or Application Source Qualifier transformation directly… 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 a source-based commit session, it identifies commit source for each pipeline in the mapping. The Integration Service writes the name of the transformation used for… 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 cause target bottlenecks. How to identify a Target Bottlenecks? Read the thread statistics in the session log. When the Integration Service spends more time on the… 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 each row in a group. Why Rank is an active transformation? Ans:- Rank transformation might change the number of rows passed through it. Can we… 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 programs that can be used to manage workflows. You can use pmcmd to start, stop, schedule, and monitor workflows. This command enables you to manage… 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. Description: Transaction and master data from OLTP (online transaction processing) systems is loaded into the data warehouse as Fact tables and Dimension tables respectively. In… 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 several objects that form power center code. Most of the objects created during the life cycle of the development are stored within the respective folders. … Continue reading How to create Repository Folder

How To Propagate Port Attributes

Propagating Port Attributes When you edit a port name in a transformation, by default, the Designer propagates references to that port in the expressions, conditions, and other ports in that transformation. You can also propagate changed attributes throughout the mapping. The Designer propagates ports, expressions, and conditions.  We can propagate changes forward, backward, or in… Continue reading How To Propagate Port Attributes

Informatica services stops automatically

Informatica Services are Getting Stop Automatically All of a sudden i couldn’t connect to Repository, I am getting an error. Usually this error comes if the Informatica service is not running. I tried to restart the service in services.msc but its not even starting. I tried many times but the result was same. My Repository… Continue reading Informatica services stops automatically

MD5 (Message-Digest algorithm 5) In Informatica

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 generate a 128-bit hash value. MD5 returns a 32 character string of hexadecimal digits 0-9 & a-f and returns NULL if the input is a… 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 date to Gregorian calendar for further informatica processing. We can use TO_DATE function to convert the Julian date to Gregorian in an expression and then… Continue reading How to Convert Julian to Gregorian date in Informatica