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
- 9239 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 the fact table?
How does the aggregator transformation handle null values?
Difference between Data and Index Caches?
What is a joiner transformation and why it is an active one?
What is Cognos script editor?
Differentiate between a database and data warehouse?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is option by which we can run all the sessions in a batch simultaneously?
Explain the shared cache and re-cache?
Can we override a native sql query within informatica?
How can we update a record in the target table without using update strategy?
What is the difference between Active and Passive transformation?
Explain Dataware house architecture .how data flow from intial to end?
What is a stored procedure transformation?
