Problem with duplicates record

[Former Member]

I have created an SAP_DataMart Fixed Query in SAP MII but I am getting duplicates records.

Also, in my parameters settings I have  - PARAM.20 - 20140601  and PARAM.21  - 20140615 for dates

Yet, I have the dates only displaying for 20140601 to 20140608?

Please see attached part of a screenshot.

Thank you.

[saumya_govil]

Hi Amr,

It probably looks like an issue with the query itself. I suggest you verify the query by executing it directly in the source data system e.g in SAP using SQ01 and see if you get the same results.

If yes, then it is a query join issue.

Regards,

Saumya Govil

[salvatore_castro]

Perhaps you have a join issue with your SQL statement and are getting a Cartesian product of the SQL results.  If you share the datamodel and the SQL you are using maybe I can help you debug your SQL.

Sam