unexpected result from joining to ETL data flows
So here is another strange happening that I do not understand. Here goes folks:
I have two data flows that I have created each contains a date column and a value column. The date columns don't match up exactly - same date but not the same time samps... anyway I want to join them so that I will have one date column and two value columns. I add a constant column with a text value of X to each of the dataflows and then I join them using the inner method by identifying and matching the constant X column... each of the datasets has about 1k rows BUT the resulting output dataset has over 1m rows... and I don't understand why?!?!?
Anyone please explain what am I doing wrong?!
Thanks in advance...