What are databases what are the uses of databases?
Explain the difference between a primary key and a unique key?
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
Who invented schema theory?
What is a 3nf table?
What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?
Where does the LGWR process writes information?
Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ?
Define entity.
What is an optimization and performance tuning and how does it really work in practical projects?
What is the difference between multiload and fastload interms of performance?
Explain the terms specialization and generalization.
How do you create a blank database?