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 […]