HCI DS - Cartesian Product issue

[Former Member]

Hi

How can we solve this cartesian product issue in CacheSplitMemoryReader in HCI DS. We are having performance issues due to this. I am doing an inner join and i have attached the data flow image and also monitor log.

Thanks

Data Flow:

[former_member361253]

Hi Ramesh,

In the monitor log i think i see two files or two sources being read. if so is there a mix of inner joins or outer joins any where in you entire transformations?

If there is one inner and one outer in the entire task? then this kind of scenario might happen.

Thanks!!

Vijay