This post is in continuation to my previous post on how to prepare for Informatica PowerCenter v9 Developer certification, in which I described the syllabus for the exam, In this post I will describe how to get the reading material for the certification and which parts to study for an efficient and effective study. Also, I would […]
Tag Archives: Informatica
How to prepare for Informatica PowerCenter v9 Developer certification – Part1 (The Syllabus)
In this multipart series of posts I will describe how to prepare for PowerCenter v9 Developer certification. I will cover topics right from getting the syllabus to registering for the exam to preparing for it. It will be a big series which will cover the complete syllabus in depth with some sample questions. There are […]
How to generate a star pattern using Informatica with a Java Transformation
This post is in continuation to my earlier post where I described how to generate a star pattern without using a Java transformation. In this post I will describe the method to generate this pattern using Java transformation. Just for the benefit of readers who have not read my previous post, below is the description […]
How to install legitimate copy of Informatica v9.6.1 on windows 7 for personal use for free – Part 5
This is the fifth part of the 6 part guide which describes how to install Informatica PowerCenter 9.6.1 for personal use How to get and unpack the legitimate copies of the software packages (see Part 1) How to install Oracle 11g and create a database for Informatica repository and domain (see Part 2) How to install […]
How to generate a star pattern using Informatica
Question:- To generate a star pattern using Informatica depending on the number of rows in the input file Suppose there are 7 rows in the source file (any type of data), the target should have 7 rows of stars in the following pattern:- Fig1 Solution:- There are two ways of doing this – first is […]
How to Load Only the first row and last row from a file to a target file using aggregator
This post describes another way of loading the first and last rows. This time using the aggregator transformation. Please see my previous post if you want to know how to do this using a Rank Transformation.(Using Rank Transformation) Here we are going to use the default behaviour of the Aggregator transformation to get the last […]