INFORMATICA SCENARIOS

1.Design a mapping to get the next row salary for the current row. If there is no next row for the current row, then the next row salary sh...

Improving aggregator transformation performence

In my last post i discussed about aggregate transformation. So now lest see how can we improve performance of aggregator transformation...

Creating your first mapping

Lets try creating first mapping from scratch. We will create a mapping to calculate max salary of employees by department. Before start...

Aggregator Transformation

Aggregator is just like a calculator in Informatica mappings. It helps us to do calculations like, SUM(+),MINUS(-), MAX,MIN etc. Lets...

My tns file got corrupted in unix

After copying tns names to tnsnames.ora it was getting corrupted.We struggled a lot to get to know why its getting corrupted and finally...

How to connect to MS-SQL server from informatica

I assume that you have installed MS-sql driver on unix. 1)Login to unix box using putty.Then change your directory path to cd /home/in...

How to Export and Import Folders in informatica

1) Open the repository Manager. 2)Select the folder which you want to copy. 3)In edit tab select copy. 4)Select the repository to w...