Why do we need foreign key?

0 Answers  

---

Explain all codd's rules for relational database system?

0 Answers  

---

What are the main components of a database in healthcare?

0 Answers  

---

1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

0 Answers   Wipro,

---

What is compound key?

0 Answers  

---

Is it possible to modify a Datatype of a column when column contains values?

1 Answers  

---

What is database definition (dbd)?

0 Answers  

---

How to disconnect the user connection?

0 Answers  

---

What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?

1 Answers   Sutherland,

---

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

0 Answers  

---

Is the server accepting tcp ip connections on port 5432?

0 Answers  

---

What do you understand by database triggers?

0 Answers  

---