Merge Join task

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Merge Join only accepts 2 inputs. Have you looked at the UNION ALL Transformation?

touchmeknot123 Right there with Babe Points: 735 More actions · Answer 2

hey Jack,

I did look into the Union ALL transformation.

I need a single record in table from 3 records in the file.

The Union ALL gives me 3 records and I need 1. so merging all of them into one record is the issue.

Thanks!

vishal.gamji SSCertifiable Points: 6126 More actions · Answer 3

U need 2 merge join transforms (1 for first 2 joins [TbaleA and TableB] and 2nd for the join of [TableA and TableB] and TableC