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
- 5021 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
According to his methodology what all you need before you build a datawarehouse
what is the difference between informatica6.1 and infomatica7.1
Explain in detail about scd type 1 through mapping.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Enlist the differences between database and data warehouse.
Write the prerequisite tasks to achieve the session partition?
How would you join a node to the already existing domain?
What is a difference between complete, stop and abort?
Enlist the advantages of informatica.
How many ways are there to create ports?
What is rank transform?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is difference between a gateway node and worker node?
What is the format of informatica objects in a repository?
