QuestionQ8Verified/Data Ingestion and Data PreparationCopy linkReport a problemAsk AstroTutorSave questionWhy does the conditional multi-table INSERT option support the Data Vault data model?AData can be inserted in parallel to hubs and satellites using surrogate keys.BData can be inserted in parallel to dimensions and facts using surrogate keys.CData can be inserted in sequence to hubs and satellites using surrogate keys.DData can be inserted in sequence to dimensions and facts using surrogate keys.Show AnswerAnswerExplanationData Vault stores business keys in hubs and descriptive history in satellites. A conditional multitable INSERT can route and fan out a source row to multiple targets in one statement, supporting parallel loading of related hub and satellite rows with the appropriate surrogate-key relationship. This differs from dimensional modeling, which uses dimensions and facts.Learn moreOracle Database SQL Language Reference — INSERTShow comments1Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion