Hi experts, For informatica developer, in real time,
normally how much we use sql and plsql?
- 2 Answers
- 8599 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 |
Can you start a batches with in a batch?
How to create or import flat file definition in to the warehouse designer?
What is the difference between a table and the materialized view?
What is Collect performance data in informatica and what is the use of it.
how remove 1st 3 records & last 3 records in informatics
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
Briefly describe lookup transformation?
Diffrence between static and dynamic cache
write a query for how to eliminate the duplicate rows without using distinct?
How you prepared reports for OLAP?
what is update strategy transformation ?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
Teradata 
