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
- 4198 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 |
Filter transformation in the condition one of the data is NULL would the record be dropped.
How will you update the first four rows and insert next four rows in a mapping?
How the informatica server sorts the string values in Rank transformation?
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
What is meant by a domain?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
Define maping and sessions?
Performance tuning in UNIX for informatica mappings?
performance wise which one is better in joiner and lookup transformation
How to eliminate duplicates in FF and oracle both
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to delete duplicate row using informatica?
Teradata 
