What are the Referential actions supported by FOREIGN KEY integrity constraint?
Submitted by: AdministratorUpdate And Delete Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.
Submitted by: Administrator
Submitted by: Administrator
Read Online Data Warehousing Job Interview Questions And Answers
Top Data Warehousing Questions
| ☺ | What is the difference between aggregate table and materialized view? |
| ☺ | "A dimension table is wide but the fact table is deep," Explain the statement in your own words. |
| ☺ | What is the advantages data mining over traditional approaches? |
| ☺ | What are data validation strategies for data mart validation after loading process? |
| ☺ | Can you pass sql queries in filter transformation? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
