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
- 4204 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 write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
Explain about perform recovery?
How to view and Generate Metadata Reports?
How we can use union transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How can informatica be used for an organization?
have you developed documents in your project? and what documents we develop in realtime?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
what is the size of u r source(like file or table)?
Teradata 
