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
In warehouses how many schemas are there?
What is union transformation?
If informatica has its scheduler why using third party scheduler?
What is update strategy transform?
In development project what is the process to follow for an etl developer from day1
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
Write the prerequisite tasks to achieve the session partition?
What are the new features of Power Center 5.0?
What are active transformations.
Explain the etl program with few examples.
What are connected or unconnected transformations?
Mention some types of transformation?
Performance tuning in UNIX for informatica mappings?
what is INFORMATICA TESTING process
What is a stored procedure transformation?