I want to run a informatica worklow after complition of
oracle procedure. That procedure is not running through
informatica and can be run at any time in database.
Informatica is in windows environment. Is it possible ? If
yes please explain.
Answer Posted / amarnath
in the pre-session of the target at session level just give
a command like call procedure_name. this will first execute
the stored proc and then the workflow will load the data.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Enlist the advantages of informatica.
Write the unconnected lookup syntax and how to return more than one column.
Differences between connected and unconnected lookup?
What are some examples of informatica etl programs?
How do you load alternate records into different tables through mapping flow?
EXL informatica Questions
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
what is unit testing?tell me proceedure
What is informatica worklet?
Write the different tools in the workflow manager?
What is the need of an ETL tool?
tell me 5 session failure in real time how can you solve that in your project?
Explain the tuning lookup transformation - informatica
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?