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 is meant by pre and post session shell command?
can anyone suggest best free Talend data integration training online
Suppose we do not group by on any ports of the aggregator what will be the output?
COM components can be used in Informatica
How big was your fact table
Explain pushdown optimization and types in informatica
How can we remove the duplicates from flat file source?
Explain pmcmd command usage in informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Informatica settings are available in which file?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Explain the etl program with few examples.
What is meant by lookup transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION