In my last post i discussed about aggregate transformation. So now lest see how can we improve performance of aggregator transformation...
Improving aggregator transformation performence
on
Sunday, 23 June 2013
Saturday, 22 June 2013
Creating your first mapping
on
Lets try creating first mapping from scratch. We will create a mapping to calculate max salary of employees by department. Before start...
Aggregator Transformation
on
Aggregator is just like a calculator in Informatica mappings. It helps us to do calculations like, SUM(+),MINUS(-), MAX,MIN etc. Lets...
Wednesday, 8 May 2013
My tns file got corrupted in unix
on
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
on
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
on
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...
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
on
The flow of mapping will be like this, You will be using two expression transformation.Of which you need to make the first expression...
Getting Cumulative Sum
on
Consider the following employees data as source employee_id, salary 10, 1000 20, 2000 30, 3000 40, 5000 Design a mapping to load the ...
Design a mapping to load each product once into one table and the remaining products which are duplicated into another table.
on
This is the flow of transformations you need to follow, First you need to sort the data,for this use sorter. In expression transfor...
Unique Constraint error
on
Scenario :We have insert else update mapping and we have look up transformation for target.When we are loading data to target data shou...
Indirect file loading
on
First lets see how to do indirect file loading. 0)import a flat file and create a mapping to load the flat file data to target.The sour...
How to open a .bin file in informatica
on
Its very simple. Go to the workflow monitor window and select tools tab.In that select import log and navigate to the folder where the .bin...
What's the difference between Stopping and Aborting the session
on
Jon and sham are very good friends. Jon is working as a informatica developer and he is very good at it. Sham wants to learn informatica an...
Removing Duplicates from Flat file source.
on
There are there ways to remove duplicates from flat file, 1)Using unix commad in session. 2)Using Dynamic look up feature of look up....
Wednesday, 13 February 2013
INFORMATICA installation on WINDOWS 7
on
Follow these steps to install INFORMATICA on WINDOWS 7 STEP 0: At least two database user accounts are required to host INFORMATICA re...
Subscribe to:
Posts (Atom)