interval match

[jim_chan]

Hi guys,

I was working on intervalmatch on sales. min_sales and max_sales. Now, there's a synthetic key. How can i solve it?

Rgds,

Jim

[varshavig12]

Resolve Synthetic key in interval match

[Anil_Babu_Samineni]

Why not noconcatenate between two directories

[Anonymous]

Did you check this?

IntervalMatch

[jim_chan]

yeah , i did follow. and thats y i got a synthetic key table. i am just wondering, how can i get rid of it.

some told me use left join, some told me to create a key.

Rgds

Jim

[Anonymous · Accepted solution]

Yes, Join is preferred while working with synthetic keys in interval match.

Check this as well?

Removing synthetic keys when using Interval Match

[jim_chan]

read, it actually says need not to remove the synthetic key.  what do you think?

[arulsettu]

in this case left join is preferable. i also used that

[jim_chan]

It says--- a left join will add columns to the fact table - which will increase the memory usage. A solution without a left join could probably use less memory.

[arulsettu]

have you tried nocancatenate ?