Showing posts with label Informatica. Show all posts
Showing posts with label Informatica. Show all posts

Thursday, 24 September 2015

Informatica Server Variables Default Values



Domain --> select Integration Service(IS)-->Processes--> General Properties 

and then edit the relevant properies to point correct path. 
You may need to restart the IS service to get effect of these changes 




Like the below page to get update  
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://groups.google.com/forum/#!forum/datagenx

Friday, 11 September 2015

Column auto mapping in Informatica



Informatica PowerCenter Designer can automatically link ports ( Columns) between transformations both by position and by name.

Go to Manu bar --> click Layout > Autolink by Name ( Or Autolink by position)
select the mapping object that you want to link (e.g. source) and drag the selected ports to another mapping object ( e.g. target)





Like the below page to get update  
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://groups.google.com/forum/#!forum/datagenx