This content has been marked as final. Show 2 replies
Is there any tool available which can automatically read the logic in the PL/SQL code? The code actually moves the data into database tables. We want to feed the data as source in Informatica. Is there a way to read the code and maybe covert to it to XML?Do you want that hypothetical tool to be able to make coffee too? :)
Seriously, your best bet is to find someone who knows PL/SQL and that will be able to back-engineer the logic into business rules you can then implement in Informatica.
Human brain is the right tool for the job.
The alternative you're suggesting is not realistic.
That would require retrieving the corresponding DIANA tree nodes (sort of pre-compiled version of the code) and interpret them.
What XML structure are you expecting? Is it some sort of config file specific to Informatica.
What does the PL/SQL code look like?