Skip to Content
0

HCI DS - Cartesian Product issue

May 04, 2017 at 05:01 PM

51

avatar image

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:

dataflow.jpg (35.5 kB)
monitor-log.jpg (410.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

vijayaraja sahadevan May 08, 2017 at 08:52 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded