Financial Services CloudAdvancedhouseholdrollupsintegration
Design Household roll-up recalculation after custodian feed partial failure recovery
Real World Scenario
Custodian feed partial failure updates 60 percent of FA balances; Household AUM roll-ups stale causing incorrect client tier and wrong service routing.
Expected Answer
• Feed batch status Complete Partial Failed on integration job object
• Block tier promotion if any Household FA feed stale flag
• Nightly roll-up recalc job after successful feed only
• Manual recalc button advisor request after ops confirms feed
• UI indicator Household AUM as of timestamp freshness badge
• Reconciliation custodian total AUM vs FSC roll-up tolerance alert
• Catch-up incremental load failed subset not full rebalance
Follow-Up Questions & Answers
Click to expand — each follow-up includes a direct, interview-ready answer
Main difference: use case and scale. Feed batch status Complete Partial Failed on integration job object. Block tier promotion if any Household FA feed stale flag. Pick based on your integration pattern and team capability. Partial feed without roll-up guard misroutes tier service—freshness gate before AUM-driven automation. Optimize for scale and operational observability.
Architect Perspective
Partial feed without roll-up guard misroutes tier service—freshness gate before AUM-driven automation.