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
- 4948 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 |
What is the difference between OLTP and ODS?
How to load a relational source into file taget?
What is power center repository?
How you prepared reports for OLAP?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
What is Target Update Override? What is the Use ?
how many types transformations supported by sortedinput?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
What is domain and gateway node?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
Teradata 
