Interested to Buy Any Domain ? << Click Here >> for more details...
Hi experts, For informatica developer, in real time,
normally how much we use sql and plsql?
- 2 Answers
- 9228 Views
- Infotech, I also Faced
- E-Mail Answers
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 IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is workflow monitor?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What will be the approach?
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 ?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the Process to creating lookup transformation in informatica
What is meant by query override?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain the different dimensions.
What is dimensional table? Explain the different dimensions.
How we can use union transformation?
Where do we use mapping variables in informatica?
What is data caches/ index caches?
