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
- 9240 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 |
hi real timers . iam waiting for ur reply regarding ETL TESTING
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
what is the command to get the list of files in a directory in unix?
Is it possible to define a single node as a Gateway node as well as worker node?
How can we use mapping variables in informatica?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
If we are using an aggregator but forget to mention the group by port .what will be the output??
Why we use stored procedure transformation?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
How does the session recovery work.
What is the difference between Normal load and Bulk load?
How will the document be delivered to me?
Teradata 
