Count of data movement

When we create a table in the DWH with merging two table. Sometime you forget one field and you have a Error message say's unbalanced data movement. The problem is finding witch field as the unbalanced movement when you have 50 field. If you could put the count of field that are merged this may help, This way we look down all the field and the one a (1) when all the other have (2),  we can find faster winch one need to correct this one. Please look the attachment picture.

TX suggestion.png


Please sign in to leave a comment.