In my mapping i have two tables A and B. A contains 13 crore B has 45 cr records. I need to join them so what I did is before joiner I put sorter for two tables.
It is throwing error that sorter cache is not enough. So I did sorting in source qualifier itself and joining at that time it is saying could not allocate in file joiner.
Please do suggest me. Can i change the cache size from auto to other.
Thanks in advance