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
How does a rank transform differ from aggregator transform functions max and min?
What is joiner change?
How do you migrate data from one environment to another?
Define enterprise data warehousing?
Informatica settings are available in which file?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is primary and backup node?
How to improve the performance of a session using sorter transformation?
What are active transformations.
What are the types of presistent cache in look up tr.
Explain in detail scd type 2 through mapping.
What is a predefined event?
What are the advantages of informatica?
Can we override a native sql query within informatica?
what is size of u r database?