If you are unable to create a new account, please email support@bspsoftware.com

 

Not getting the right number of rows in a fact build

Started by lebronjames, 01 Apr 2009 06:44:38 PM

Previous topic - Next topic

lebronjames

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.

specialist

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.

emma

You have duplicates in your attributes mappings between source and target.