Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 5014 Views
- Accenture, I also Faced
- E-Mail Answers
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 a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
Mapplets can you use an active transformation in a mapplet,
Explain sessions. Explain how batches are used to combine executions?
How to differentiate between the active and passive transformations?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what is the difference between stop and abort?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
How we can create indexes after completing the loan process?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
How you count the number of records available at your source?
Teradata 
