Informatica Scenarios

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

https://8df97582-1653-4ad7-8aa0-ed6236ea011a.usrfiles.com/archives/8df975_cbf4746bf04e436b9e0d2eaeeac7c424.zip

EVERY NTH ROW

https://8df97582-1653-4ad7-8aa0-ed6236ea011a.usrfiles.com/archives/8df975_faf19371b3d24af09c0ca76e4510e158.7z

Insert Records In Cyclic Orders

https://8df97582-1653-4ad7-8aa0-ed6236ea011a.usrfiles.com/archives/8df975_de7006309ca54068b96f48f8dc83e1f3.zip

Seperating Duplicate And Non-Duplicate Rows

https://8df97582-1653-4ad7-8aa0-ed6236ea011a.usrfiles.com/archives/8df975_ae99a4c1531c4ddbb606af2a713ddcf3.zip

SPLITTING TABLES (NON KEY COLUMNS TO DIFFERENT TABLES)

https://8df97582-1653-4ad7-8aa0-ed6236ea011a.usrfiles.com/archives/8df975_682b6a21b6ad4b76a19077c9d6f7f8a1.zip

SCD_TYPE1

https://8df97582-1653-4ad7-8aa0-ed6236ea011a.usrfiles.com/archives/8df975_bda52a0f2ab4420995934ec563a9a858.zip

Will Upload some more samples in the next post.