Hi,
I am working on informatia in a support role. We used
stored procedures in informatica and other than that I
never got a chance to work on PL/SQL,little on Unix
scripts. But I heard people asking about PL/SQL alot. Can
any one let me know how do we use PL/SQL with informatica
and if required what is the knowledge that we need to have
on PL/SQL? Please let me know in detail which would really
help me alot in my career prospectus.
Answer Posted / abhinaw prakash
We use Pl/Sql for writing Procedures that we are calling
either in Post SQL or Pre SQL.
If you are working in support best way to start in PL/SQL is
to start with Procedure.Mostly the interviewer ask these only.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the informatica performance improvement tips
Explain the difference between mapping parameter and mapping variable?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what is the size of u r source(like file or table)?
is it possible to index the data in cache of lkp transformation ?
What are the differences between a connected lookup and unconnected lookup?
What are the different ways to implement parallel processing in informatica?
what are the deliverables?in your project?
What is a repository? And how to add it in an informatica client?
Is stop and abort are same in informatica?
How to update source definition?
How to start a workflow using pmcmd command?
What is aggregate cache in aggregator transformation?
What is DR strategy for Informatica project?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?