I have table C in which i am inner joining two tables A and B. Then there is another table D where i am aggregating some fields from table C..
inner join (C)
group by .....
Now the problem is that after C table has been loaded, It takes a lot of time to load table D. When i looked into the log i found that after table C has been loaded, there is a statement Joining/Keeping after which table D starts loading. However, I would not want this table D to be joined to anything. I am just loading data from the previous table C. Can someone help please
Thanks for your response. Actually the scenario is now as below, and now i am getting the table not found error..I am using some base tables and then some derived tables. in the last inner join, i get the error that table not found even though the table has been successfully create, which i can verify from the logfile too. As I have identified below, the error occurs only in the last statement. I have also tried to qualify the tables after calandar table so that each table has a different name but then it gives out of memory error. Can you please help
Planning_View: LOAD PLAN_WEEK as PV_PLAN_WEEK, ITEM_CODE AS PV_MM_ITEM_CODE, FORE_WEEK as PV_FORE_WEEK, ITEMDEMAND FROM (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
Calandar: LOAD PERIOD , WEEK FROM (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
Plan_Calandar: LOAD PERIOD AS PV_PLAN_PERIOD, WEEK AS PV_PLAN_WEEK RESIDENT Calandar; INNER JOIN (Plan_Calandar) LOAD PV_PLAN_WEEK RESIDENT Planning_View;
Fore_Calandar: LOAD PERIOD AS PV_FORE_PERIOD, WEEK AS PV_FORE_WEEK RESIDENT Calandar; INNER JOIN (Fore_Calandar) LOAD PV_FORE_WEEK RESIDENT Planning_View;
Max_Plan_Calandar: LOAD PV_PLAN_PERIOD, MAX(PV_PLAN_WEEK) AS PV_PLAN_WEEK RESIDENT Plan_Calandar GROUP BY PV_PLAN_PERIOD;
Max_Fore_Calandar: LOAD PV_FORE_PERIOD, MAX(PV_FORE_WEEK) AS PV_FORE_WEEK RESIDENT Fore_Calandar GROUP BY PV_FORE_PERIOD;