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 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,
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 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...
Hi,
Check if in 'Informatica Server Setup'->'Repository' tab,
the repository username and passwords are same as the database user name and password.
See if this helps.
Hi,
Check the 'Update as update' option.
I think you might have to specify a primary key also, in your target table for this transformation to work.
'Update as update' will only update an existing row and will not insert another row in the target table.
Also, read 'Setting the Update Strategy...
Hi,
This reg the 4th question.
First check if the you have made the task and created a workflow using this task, for the mapping in the workflow manager.
Without a proper workflow in Workflow manager, you would not be able to debug thru Mapping Designer.
See that you have assigned the workflow...
Hi,
Please check if the 'INformatica Repository server' and 'Informatica Server' services are running on your system
Also, check if in 'INformatica Server setup'-> 'Repository
', the username and passwords, are database username and passwords ( where your repository is ).
See if this works.
Please tell me how to implement update strategy transformation?
i.e. should the source table have a primary key?
What changes do I need to make in property tabs?
Please explain the steps one by one.
I have recently started working in Informatica.
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.