Investec interview question

Technical Informatica question. Basics and scenario based.