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
- 9085 Views
- Infotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ajay konidena
we can't say how much we use .
it is depend on the project requirement so
u must have deep knowledge on both sql,plsql of any DB
| Is This Answer Correct ? | 9 Yes | 1 No |
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 |
What are the different types of olap? Give an example?
Explain what are the different versions of informatica?
How many repositories can we create in Informatica?
how to return multiple columes through through un-connect lookup?
in performance wise union is past,union all is past
What is a surrogate key?
Explain what transformation and how many are there in informatica?
What is the use of transformation?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
what are the Methods For Creating Reusable Transformations?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
Teradata 
