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...
My tns file got corrupted in unix
on
Wednesday, 8 May 2013
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....
Subscribe to:
Posts (Atom)