Latest Answer : thq for ur reply....cud plz tell me wher we can use this stored procedure transforamtion,update strategy trnasformation with ex:..waits for ur reply ...
Hi all,Could anyone tell me why session fails when running a workflow? I don't see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.ThanksKamalnayan
When i was running workflow manager i.e, when i right click the task icon and clicking start workflow from task, i am getting a message like 'cannot connect to the server'. Can any body guide me, how to get the output.Thanks
Latest Answer : we take source data from databae like oracle or any other database .. 1 st we take source data in import option in source section in desginer... ok thanks ...
Im trying to fill a primary key field of a target using a trigger on the table to insert a sequence number for each insertion of a new row.After running the session im finding that the key column is populated ,but,not in an order. the key field starts with some 75 goes till 200,the again 551 comes and goes till 10500 ,suddenly the next key field is filled with 21 and goes till 72.... is there any reason why this is happening in this reason.FYI : i truncated the table data ,then dropped the seq.
When I use the Informatica Workflow Monitor, I can see the properties by double clicking the running session task. But where is the file about the properties, because I want to read the information of
Latest Answer : The properties will be stored in a table of Repository data base.Please check the tables.For any further queries: sriram_kumar@oneindia.in ...
I am getting this error "ORA-14050: invalid ALTER INDEX MODIFY PARTITION option" while running a procedure through informatica session. But the same procedure is executed successfully and doing
Do we have any specific number which we have to use with kill command?
which is primary server process in informatica?1.repository manager 2.load manager 3.workflow manager 4.workflow designer
Latest Answer : hi.."load manager' is the primary process of informatica power center server"DTM-data transformation manager" is the secondary prcess..go through the architecture of informatica power center server..thank u...suvashis ...
What is the complete process in Informatica power center client tool? Explain using ETL tool
