Out of object memory issue

[Anonymous]

Hi Team,

Need your help in this issue, we are trying to join 3 tables through left join and after joining 3 table, we are getting "Out of object memory" error.

Below is the attached file for your reference.

Kindly let us know, if we are missing out any step.

[Anil_Babu_Samineni]

Seems, I can't open application. Can you share your script?

[Chanty4u]

try with left keep and reload once

[Anonymous]

Hi Chanty,

Thanks for your reply, its solved the error, but we need all the fields in one single table and dont want to keep them separated.

Regards

Abhijit

[olivierrobin]

hello

how many rows do yo have in each table ?

is each value of key  unique ?

if not, your load will multiply each row on the left by the number of times the same value of key is present in the right

-> this may generate a huge number of rows

[Anil_Babu_Samineni]

Simply load normally without any joins and see how data model looks?

[jyothish8807]

Hi Abhijit,

Normally keeping to many fiuelds in a table is not a good practice as per my suggestion. Table starts hanging/crashing and cause out of memory sometimes.

Why don't to try to implement "Customized tables" ? It will give flexibility to user to select only the required fields as per the scenarios.

Customizable Straight Table

Br,

KC

[Anonymous · Accepted solution]

Hi All,

Thanks  for your suggestions.

We have resolved this issue by following a different method.

Thanks & Regards

Abhijit Mishra