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 […]
Read MoreCategory: Informatica
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 […]
Read MoreHow 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 […]
Read MoreCreate 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 […]
Read MoreHow 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. […]
Read MoreHow 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 […]
Read MoreInformatica 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 […]
Read MoreMD5 (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 […]
Read MoreHow 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 […]
Read MoreInformatica certification – Update Strategy Transformation
Update Strategy Transformation – My Notes How rows are flagged for insert, update, delete, or reject within a mapping? Ans:- Using Update Strategy transformation. We can also use the Custom transformation to flag rows for insert, delete, update, or reject. What are the different levels we can configure update strategy? Ans:- (1) Within a session, […]
Read MoreInformatica certification – Aggregator Transformation
Aggregator Transformation – My Notes What is the use of Aggregator Transformation? Ans:- Aggregator transformation can be used to aggregate calculations (Avg, Sum, Max ..) on groups. Since its changing the number of rows its an active transformation. What are the Components of the Aggregator Transformation? Ans:- Aggregate cache, Aggregate expression, Group by port & […]
Read MoreInformatica certification – Transformations
Working with Transformations – My Notes — Transformation Overview — Which is the repository object that generates, modifies, or passes data? Ans:- A Transformation. Which transformation performs calculations on groups of data? Ans:- Aggregator Transformation. What are the actions performed by Active Transformations? Ans:- Change the number of rows that pass through the transformation, Change […]
Read MoreInformatica certification – Lookup Transformation
Lookup Transformation – My Notes What is Lookup transformation? Ans:- It can be used to look up data in a flat file, relational table, source Qualifier, view, or synonym. What are the various tasks can be performed by Lookup Transformation? Ans:- Get a related value, Get multiple values, Perform a calculation, Update slowly changing dimension […]
Read MoreHow to remove duplicate records using Sorter Transformation
How to remove duplicate records using Sorter Transformation In the last two post we have seen how to remove duplicate records (Only one column) using Aggregator and Expression. We have identified the duplicate JOB_ID and skipped those rows from loading to target. The same logic CANNOT be done using Sorter Transformation. In sorter we cannot […]
Read MoreHow to load every 5th record into target table
How to load every 5th record into target table We need to read the source table and load only 1st and every 5th (nth) records to target. Let’s start the mapping for this. We need a sequence generator and a filter transformations to complete this requirement. The logic which we are following here is to assign […]
Read More