Answer / Nirbhaya Singh

Here's a step-by-step procedure for using stored procedures in Informatica 7.1:n
1. Create a new session or open an existing one.
2. Add a Source Qualifier transform if you are reading data from a database, or a Target Qualifier transform if you are writing data to a database.
3. Right-click on the Source Qualifier/Target Qualifier and select 'Database Connections' from the context menu.
4. In the Database Connections window, define the connection details for your database (server name, user name, password etc.).
5. Once the connection is established, right-click on the database and select 'Create New Stored Procedure.'
6. In the 'Create a New Stored Procedure' dialog box, enter the stored procedure name and the database schema.
7. Enter the stored procedure code (SQL statement) and click 'Finish'.
8. The newly created stored procedure will be available in the Database Explorer.
9. You can now drag-and-drop the stored procedure into your session, or use it as a source or target for data transformation.

How concurrency problems effect the database?

1 Answers   BirlaSoft,

---

What are the types of indexes that are present inside a database?

1 Answers   Abacus,

---

where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

1 Answers  

---

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

1 Answers  

---

Which is the best sorting method if i have to sort the students of Harvard University according to their first name?

1 Answers   CybAge,

---

How to do Data integrity testing? Who does this testing (Developer or tester)?

1 Answers  

---

What is the difference between primary key, foreign key and candidate key?

1 Answers   Ernst Young,

---

hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

1 Answers   HP,

---

What are the three types of anomalies in database and Explain?

9 Answers  

---

Explain normalization in one line?

1 Answers   C DAC, CDAC,

---

What happens when shared and exclusive locks are applied on data item?

1 Answers  

---

How do I manually create a database?

1 Answers  

---