Happening Cardinality in join stage
Posted: Tue May 06, 2008 6:12 am
Hi All,
here i am joining two tables using(left-outer) Join stage, in which left table contians 4000000 records and right table 2500 records joining with Join stage .when I am loadind data into next stage(join) records are multiplied(Cardinality) and I am getting error message which says "APT_CombinedOperatorController(0),0: Operator terminated abnormally: Terminating with exception:APT_BadAlloc: Heap allocation failed"..kindly give me the solutions.
Note:no need to use merge stage and lookup stage
Thanks
Srini
here i am joining two tables using(left-outer) Join stage, in which left table contians 4000000 records and right table 2500 records joining with Join stage .when I am loadind data into next stage(join) records are multiplied(Cardinality) and I am getting error message which says "APT_CombinedOperatorController(0),0: Operator terminated abnormally: Terminating with exception:APT_BadAlloc: Heap allocation failed"..kindly give me the solutions.
Note:no need to use merge stage and lookup stage
Thanks
Srini