Computer Science · Data Warehousing
When integrating semi-structured XML logs from trading APIs into a relational data warehouse, which ETL strategy conceptually minimizes schema evolution risks while preserving analytical flexibility?
- 1Ignore XML hierarchies and extract only scalar values
- 2Store the XML in a hybrid relational-XML column or staging document store to separate ingest from schema mapping✓
- 3Convert to NoSQL storage post-warehouse
- 4Flatten all XML into fixed columns during extraction
Correct answer
Store the XML in a hybrid relational-XML column or staging document store to separate ingest from schema mapping
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Data Warehousing?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Data Warehousing