Skip to Content
0
Apr 22, 2014 at 03:15 AM

Double records in Delta

142 Views

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!)