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

What are the issues you have faced in your project? How did you overcome those issues?

1914


How to handle decimal places while importing a flatfile into informatica?

725


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

4310


Slowly changing dimensions, types and where will you use them

1273


What are the tasks that can be performed using sq?

615






Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

602


What is main use of mapplet?

660


How can we store previous session logs?

569


Explain constraint based loading in informatica

659


What you know about transaction control transformation?

559


How to start a workflow using pmcmd command?

713


What is a grid in Informatica?

610


What is deployment group?

689


Can we create multiple integration service on single repository?

701


define galaxy repository in informatica

1729