Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 8142 Views
- I also Faced
- E-Mail Answers
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
How to elaborate tracing level?
Explain direct and indirect flat file loading (source file type) - informatica
waht type of interface is used for testing the data in informatica
Write the program through which the records can be updated?
What is a filter transformation and why it is an active one?
Explain dynamic target flat file name generation in informatica
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What is the difference between writing a joiner query in ANSI style and THETA style?
Write the prerequisite tasks to achieve the session partition?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are the different versions of informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is the reusable transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain in detail scd type 2 through mapping.
