Recent content by sandhu

Hi, I have an excel time-sheetand, in which, for each number of hours entered in the cells, a comment has been entered. I have imported the data in the cells, but also need to import the comments given in each cell. Please help,how can I import the comments into an Access database. Thanks in...

Hi, I have an original mapping, which has flat-file as source and Oracle database tables as target. This mapping has been restored from a backup repository, which was being used somewhere else. Now, I want to use this mapping with my local flat-file source and Oracle database tables. I tried to...

Hi, Check if the Server Edit information in the Workflow Manager is same as in the Start->Informatica Server Setup->Server tab. The Server names and the IP addresses should be the same. Also, if you have more than 1 Informatica Servers, check if you have 'assigned' the workflows to the...

Hi, Please ignore this thread. SOrry for the trouble people:) I got the solution from 'Creating a Local shortcut' section in the PowerCenter/PowerMart Help. Regards, Harsimran

Hi, Please let me know how to implement shortcuts for sources, targets and transformations in Mapping Designer. Thanks in advance, Regards, Sandhu

HP-UX

Hi, Has anyone installed Informatica on Unix? If so, then please let me know about the version for Unix. Thanks in advance, Sandhu

Hi ProDev, Reg your first query, you can get the output thu the account_id port. For s_account_id, add a new port (say new_account_id) and input the source account value in it. If 'new_account_id = account_id', then account_id will pass the value other wise NULL will be passed. See if it...

Hi, Go to the Help file. In the 'Supplemental Guide', go to 'Chapter 9 : Upgrading a Repository'. Follow the steps given in it. As you have the Informatica 5.1 mapping, so the repository version will be 102. So, you dont need to recover the files from the backup. You can follow the steps given...

Hi, Is there any Informatica Certification program availabe? Thanks in advance, Sandhu

Hi, Please tell me how can I implement 'Update as Insert' in Update Strategy transformation? I have implemented 'Update as Update' and 'Update else Insert' using the look-up transformation. But, for 'Update as Insert', if I tick the boxes 'Insert' and 'Update as Insert' in the Edit...

Hi, Thanks for the help Can you please tell me that which service I should stop, in order to close any debugger service running earlier on my system. Regards, Sandhu

Hi, While debugging, I am getting an error -- Initializing debugger... bind: (WSAEADDRINUSE)Address already in use Thanks in advance

Hi Dinzana, Thank you for your reply. It really helps when someone helps you out quickly. I think the solution you told should solve the problem. Thanks again,

Hi dinzana, Thank you so much for a very detailed reply. Please also tell me, that in 'update else insert' and 'update as insert', do I have to select the 'insert' checkbox in the Target properties? And, that while doing 'update as insert', should the primary key be removed from target table...