Hi,
Have below flow from a flat file:
Level 1 Standard DSO -> Level 2 Standard DSO -> Cube
Have a query regarding the working of Delta.
ID Name Role Amt
Req 1 -> 1105 Marina Consultant 1000
Req 2 -> 1105 Marina Hopkins Consultant 1000
When I load req 2 as Delta from Source, the change log has N, X, ' ' records as we know:
1105 Marina Consultant 1000 N
1105 Marina Hopkins Consultant 1000 ' '
1105 Marina Consultant 1000 X
Question is reg cube. Since its delta, it picks up from changelog, but its also picking X record. Am I missing anything here or it only aggregates Keyfigures and that too if CHAR are same?
Cube Content:
Req 1 -> 1105 Marina Consultant 1000
Req 2 -> 1105 Marina Hopkins Consultant 1000
Req 2 -> 1105 Marina Consultant 1000 (Duplicate and X record!)