Search

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.





3 views
  • Facebook
  • Twitter
  • LinkedIn