dimTableNameName of the dim table to perform the lookup on.
dimColToLookUpThe column name of the dim table to be retrieved to decorate our result.
dimJoinKeyThe column name on which we want to perform the lookup i.e. the join column name for dim table.
factJoinKeyValThe value of the dim table join column for which we will retrieve the dimColToLookUp for the scope and invocation.