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
Parameter and variable differences
is it possible to index the data in cache of lkp transformation ?
What is sq transformation?
What are the designer tools for creating transformations?
Write the different tools in the workflow manager?
Why sorter is an active transformation?
What is the use of transformation?
What is a repository? And how to add it in an informatica client?
What is data movement mode in Informatica and difference between them?
What is dimensional table?
can anyone explain me about retail domain project in informatica?
can u any challenge your project?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is lookup change?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?