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 / 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 |
How to generate or load values in to the target table based on a column value using informatica etl tool.
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
how do the project develops? pls specify right from the start to end in step by steps.
What did you do in source pre load stored procedure
Name 4 output files that informatica server creates during session running?
How to extract sap data using informatica?
what is mean by complex business rule ?
What is hash partition?
Explian the connected and unconnected lookup transformation
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?