Finding alternative for Join/Union Snap?
As per my project, we are NOT ALLOWED to use join/union snap in our pipelines as according to their theory, it reduces the speed of the pipeline.
Can someone help me in finding the alternative?
T...
Forum Discussion
Hi – I know this is an old post – but wanted to ask:
Should JOIN “merge” “unsorted” behave similar to UNION?
I found a recent issue where the output data from each is totally the same, but the JOIN caused 4000+ rows of data to hang and not return, but UNION resolved it in an instance. Just curious the difference with “merge” and why this may have happened.
TIA - Melissa
Both are different.
Sample Input Data:
Join - Merge : Will append data by adding columns(merge vertically). In case column name matches, column will rename. The number of O/P records will be maximum of the input views.
O/P of Join Merge
Union: Merge two streams by adding rows(merge horizontally). In case column name matches, data will populate in same column. The number of O/P records will be sum of all input views records.
O/P of Union
