I am attempting to load/replace a target table in key order (two columns). The target table contains about 5 million rows. In the Query transform, loading to the target table I use the “Order By” function and drag/drop the two columns to that tab. After loading the table I do a simple Select * query against the table with the “Fetch first 1000 rows only” option and when I view the results they are not in the order I specified. They are close to the order, but random rows are in the output that are not in the correct order.
Any idea why I can’t get this table loaded in the specified order?
Thanks in advance for any help.
Longrun4fun (BOB member since 2008-10-22)