What is the difference between procedure and stored procedur?
Answers were Sorted based on User's Feedback
Answer / raja
Hi,
I think, Diff b/w Application Procedure and Stored
Procedure.
Application Procedure developed in Oracle Developer tools
such as Forms, etc and stored in the same application.
But Stored procedure stored in oracle server.
| Is This Answer Correct ? | 1 Yes | 5 No |
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
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 ?
how can you load data into target table without leading zeor's
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What if the source is a flat-file?
How i can upload the MainFrame source For Informatica ?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
WHAT IS FACT TABLES?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how