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
- 9084 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
How many ways are there to create ports?
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 ?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Is there any target staging area in informatica not staging area
Describe data concatenation?
What are the uses of etl tools?
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 informatica? Why do we need it?
Name the different lookup cache(s)?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Describe the impact of several join conditions and join order in a joiner transformation?
How will the document be delivered to me?
differences between service based and product based?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
