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
- 5015 Views
- Accenture, I also Faced
- E-Mail Answers
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
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
If informatica has its scheduler why using third party scheduler?
Performance tuning( what you did in performance tuning)
Where is metadata stored?
How can a transformation be made reusable?
EXL informatica Questions
Separate from a database, an information bazaar, and an information stockroom?
What are different types of transformations available in informatica?
How can we use mapping variables in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
update strategy transformation in informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Mention few advantages of router transformation over filter transformation.
How do you load unique records into one target table and duplicate records into a different target table?
What are the mapping parameters and mapping variables?
