Hey,
We have a staging table that pulls in data from a DB2 mainframe database. The underlying SQL when executed in the SQL Term displays the exact row that we need. But when we execute the fact build, it comes up with 4 duplicate rows. The source and the target are both correct with the SQLTerm.
Do you have any ideas as to why this would happen?
Thanks in advance.
You might have run the build multiple times and module property could be Append.
Check the Module properties of Table Delivery, by default it's Append. You may want to change to Truncate.
You have duplicates in your attributes mappings between source and target.