Hi experts, For informatica developer, in real time,
normally how much we use sql and plsql?

Answer Posted / chinni

If your'e well versed with Oracle. In performance point of
view use pre-sql and post-sql or sql query in source
qualifier transformation. If your'e having minimal
knowledge on sql or pl/sql then go for Informatica bcz its
a 3rd party tool which will give solutions in less time
than Normal Oracle.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Repository user profiles

1383


define galaxy repository in informatica

1736


What is the way to execute pl/sql script using informatica mapping?

979


What is the difference between router and filter?

654


What is data movement mode in Informatica and difference between them?

630






Define the various join types of joiner transformation?

567


How to convert multiple rows to single row (multiple columns) in informatica

906


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1867


How can you differentiate between powercenter and power map?

638


Differentiate between joiner and lookup transformation?

624


Target increases every day even though no new record was inserted

1116


Please let me know how to make Data masking in informatica..

1281


How can repository reports be accessed without sql or other transformations?

738


Can we create a Integration service without a Repository service and vice versa?

733


EXL informatica Questions

941