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
What are the issues you have faced in your project? How did you overcome those issues?
How to handle decimal places while importing a flatfile into informatica?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Slowly changing dimensions, types and where will you use them
What are the tasks that can be performed using sq?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is main use of mapplet?
How can we store previous session logs?
Explain constraint based loading in informatica
What you know about transaction control transformation?
How to start a workflow using pmcmd command?
What is a grid in Informatica?
What is deployment group?
Can we create multiple integration service on single repository?
define galaxy repository in informatica