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 load only the first and last row from a flat file to a target file using Rank transformation?

This is a common interview question which can really test the candidates’ knowledge of informatica transformations and logical thinking. The caveat here is you have to do this without using any pre-session commands So here we need to single out the first and last row from the source file. Lets take an example source file […]