DSXchange

Hi All,

I have two different files. I want to merge two files but I don't have any common keys. So I have created a dummy key to merge two files. Master link having 13rows and reference having 5rows. But after merging, I am getting only 17rows. One row is missing. Please help me to get 18rows in my output.

Thanks in advance.

In the both the link choose the partition method as hash and provide dummy column created as key

Hi,
Take a reject link from update and check "drop" method in merge stage, lets see one record should go to reject.

Is the key unique on both the links ?

Hi,
I think master inputs of the merge stage should not be duplicate on the key column.as part of preprocessing your data for merge stage,you should remove duplicate records from master dataset and if you have more then one update datasets,you must remove duplicate records.

Yes you are right prasson. If its duplicate then the data rejects are obvious.

Why really you need to merge when you do not know the keys? Anyways if you are merging it based on keys, and expecting total number of records, which means there won't be any record which will match. Why not use funnel in that case. May be just a bad choice of stage or you don't know why you need to merge it.

A little more details will help here.