I have a client running Imp 7.5 against a SQL Server 2005 (on Win 7), a 1-table View. When I run the View in SQL Server, I only get one row per ticket_No field. Total 900,000 rows
When I run the IMR, I get three duplicate rows per Ticket_No field/column, save as IQD and run Transformer - Very fast - but triple the measure values (if summed)
- so I use the remove Duplicate Rows option in IMP, run the IQD in Transformer, and now it takes 5 minutes to complete 1000 rows - this is unacceptable.
Does anyone know of a performance issue or a tip to get Transformer to read "Distinct" IQD files faster?
Thanks
If you open the IQD in Notepad, how has the SQL query been defined? Is there anything in there which you can see would cause the duplication?
MF.
The IQD shows that the "Ticket_No" is only coming from the source SQL Server View table. I will have to verify that the column in the View is actually the master column and not the detail one, but I doubt that since, as mentioned, when running the View in SQL Server - I do not get the duplication of rows?????
Also when running the SQL from the IQD separately - no duplication (more question marks???)
Thanks - I'll Keep looking