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 create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
without using emailtask how will send a mail from informatica?
What is critical mapping?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
can you please explain me pre session and post session options?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to create Target definition for flat files?
Explain target update override in informatica
i have 2 session s1 execute s2 load first session fail what is the reason?
what are the difference between Informatica 7.1 and 8.1?
TELL ME ABOUT WORK FLOW SCHEDULING?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?