Salesforce Decode
Salesforcedecode
Back to questions
Data CloudBeginneringestionbatchstreaming

What is the difference between batch and streaming ingestion?

Real World Scenario

Web events need near-real-time personalization but billing files arrive nightly. You compare ingestion modes.

Expected Answer

• Batch ingestion loads files or scheduled extracts on intervals—hourly, daily • Streaming ingestion processes events continuously with low latency • Batch suits large historical loads and warehouse exports • Streaming suits web behavior, mobile events, and timely triggers • Choose mode based on freshness needs and source capabilities

Follow-Up Questions & Answers

Click to expand — each follow-up includes a direct, interview-ready answer

Sometimes—historical backfill via batch and ongoing updates via stream. Avoid duplicate logic with clear primary keys.

Architect Perspective

Freshness vs cost is the tradeoff interviewers want—young consultants often over-index on real-time.