DSXchange

I want to confirm from you guys , Is it possible to do full outer joins and UNIONS in DS without any problem? And I think the only way to do is to use User defined SQL right??

DeepakCorning wrote:I want to confirm from you guys , Is it possible to do full outer joins and UNIONS in DS without any problem? And I think the only way to do is to use User defined SQL right??

Yes. I have done that in User Defined SQL with out any problem.

You can achieve the same effect with a series of hash files and passes thru the data. But it would not be the elegant solution. If a UNION is what you desire, that is a database action best suited to be done in a database. a UNION ALL can be achieved by simply concatenating like structured text files together. A full outer join can be achieved thru a similar concatenation of like structured files followed by a merging operation using something like the Aggregator stage to group by a the merging key fields and MAX(xxx) operating the remaining fields.

Like kcbland sez about UNION ALL - you can do it by concatenating text files. A nice way of doing this with DS is to have each of your separate SQLs feeding into a Link Collector stage.

These (Funnel and Remove Duplicates) are parallel stage types, not available in server jobs.

u can do this by using with merge stage( in that there r so many options to do the join options )
complete set is for full outer join
just confirm