Get excluded rows? 1

[tigerjade]

Any idea how I can get rows that did not meet the criteria in a merge join?

"Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you live." -- Martin Golding

 

[MDXer]

The only way I jnow is to change the join from an inner to a full. Then after the join put a Conditional split in and add logic to redirect the rows that don't join up to different data flow where you can do what you want with them.

Unless your tables reside on 2 different servers I would also recommend you push any joins back to the source query as the need to have sorted dataflows in order to preform the merge adds substantial overhead in the process. Pushing the join back to the DB by doing it in the source query can have a significant improvement if the underlying indexes support the query. At the very least you should do the ordering in your source query.

 

[tigerjade]

That'll work! Unfortunately, I have data coming from a flat file and a database server, so joins have to be in the system. I'm pushing as much as I can to the query, though.

"Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you live." -- Martin Golding

 

[MDXer]

Push your order by to the database for that query and set the order properties in the advanced editor of the data source.