How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?
Answer / kalyan
If the stored procedure id used to do any operations on the
database tables (say Dropping the indexes on the tgt table
or renaming it or truncating it)then call them at the Pre
SQL and Post SQL options at the session properties of the
Target.
| Is This Answer Correct ? | 12 Yes | 5 No |
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
Can we run session without using workflows?
What are the tasks that can be performed using sq?
How to run a session, which contains mapplet?
Performance tuning in UNIX for informatica mappings?
What is version control in informatica ? Advance thanks
can anyone suggest best free Talend data integration training online
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties