Once you install PowerCenter on your system the question which starts thumping your brain is how to get started in this post I have attached some sample Informatica transformations. The said transformations also contain an import file that can be easily imported through the repository manager of the designer tool.
Converting Rows to Column
EVERY NTH ROW
Insert Records In Cyclic Orders
Seperating Duplicate And Non-Duplicate Rows
SPLITTING TABLES (NON KEY COLUMNS TO DIFFERENT TABLES)
Will Upload some more samples in the next post.