Sorting and writing to Oracle Enterprise stage

[ds_is_fun]

1. I first have source data in an ODBC stage coming from Sql Server.
2. I then transform the data in a transformer stage.
3. Then I use a Sort stage. I need sort by Date_Id. Im using a hash partition and selecting perform sort ..this makes it show as Date_Id (performing and sorting) in the SORT stage.
4. I then need to write to Oracle through Oracle Enterprise Stage. I have set partitioning to "Sequential" and using "Sort Merge" in the collector type.
I have tried both options- Checking Perform sort and un-checking perform sort and key is Date_Id.
5. When I view my data it is not inserted correctly sorted.

I tried using sequential file stage instead of Ora Enterprise stage and used sort merge for collection and it worked.

Pl. help on how could achieve sorting in this job.
Thanks!

[chulett]

5. When I view my data it is not inserted correctly sorted.

Sorry, but what the heck is this supposed to mean? There's no sort order in the database, and you can only see sorted data when you view the data if your select query explicitly sorts the data. It's a relational database, not a flat file.

Short answer - you're trying to solve a non-existent problem.