Blank-Page Reconstructions & Key
Draw first. Then compare to the key immediately below each task.
1. ETL vs ELT
Prompt: draw both side by side.
Key: ETL = Source → Extract → Transform → Load → Target. ELT = Source → Extract → Load raw → Transform in Target. Circle transformation location.
2. Latency ladder
Prompt: draw batch through streaming/synchronous.
Key: Batch/scheduled → Micro-batch → CDC/near-real-time/event-driven → streaming/very-low latency; add synchronous where immediate current-process confirmation is required. Lower latency can increase dependency/cost/complexity.
3. Interaction models
Prompt: point-to-point vs hub-and-spoke vs publish-subscribe.
Key: direct pairwise links vs exchange through common hub/canonical representation vs producer publishes once to multiple subscribers.
4. Coupling
Prompt: tight vs loose.
Key: Tight/sync = waits + shared availability/blocking. Loose/async = sender continues + receiver may be temporarily unavailable with reliable queue/retry.
5. Full lifecycle
Prompt: Plan & Analyze → Design → Develop → Implement/Monitor with activities.
Key:
- Plan & Analyze: requirements, discovery, lineage, profiling, business rules.
- Design: architecture/interaction, services/messages/models, mapping, orchestration.
- Develop: services, flows, migration, publication, CEP.
- Implement & Monitor: activate/monitor, maintain DII Metadata.
6. Evidence-to-execution order
Prompt: discovery → profiling → mapping → orchestration; explain why.
Key: discovery identifies source candidates → profiling tests actual data → mapping defines conversion → orchestration defines execution order/dependencies. Lineage spans origin/movement/transformation across the flow.
7. EAI / ESB / SOA / CEP
Prompt: four boxes with one deciding clue each.
Key: EAI = app interfaces/APIs; ESB = message intermediary; SOA = reusable independent services; CEP = event-pattern interpretation + triggered action.
8. Federation / Virtualization / DaaS
Key: Federation = combined access; Virtualization = one logical view over heterogeneous stores; DaaS = governed data delivered on demand. None automatically implies warehouse persistence.
9. Governance trust chain
Prompt: business rules → Metadata/lineage → approval → sharing agreement/SLA → monitoring.
Key: business meaning → preserved evidence → steward/business approval → explicit exchange obligations → operational evidence/improvement. Technical implementation follows governed meaning.
10. Metrics
Key: Availability | Volume & Speed | Cost & Complexity. Add one actionable measure to each and tie it to a consumer/management decision.