Hi All,
We are getting a unique problem. The Script which we are running is working fine in one environment but in another environment it is giving Table not found Error.
The part of script is :
Max_Weekend_Date:
LOAD %ISSP_Date_Dim_Id as Date_ID
Resident Phyn_Rx_Weekly_Fact;
inner join
LOAD
Week_End_Date as Ims_Week_Code ,
%ISSP_Date_Dim_Id as Date_ID
Resident Date_Dim;
--------------------------------------------------------------------------------------------------------------------------
Log file contents:
5/10/2013 1:11:30 PM: 0491
Resident Phyn_Rx_Weekly_Fact
5/10/2013 1:11:30
PM:
1 fields
found: Date_ID, 2,870,400 lines fetched
5/10/2013 1:11:38 PM: 0493
inner Join
5/10/2013 1:11:38 PM: 0494
5/10/2013 1:11:38 PM: 0495
LOAD
5/10/2013 1:11:38 PM:
0496 Week_End_Date as Ims_Week_Code ,
5/10/2013 1:11:38 PM:
0497 %ISSP_Date_Dim_Id as Date_ID
5/10/2013 1:11:38 PM:
0498
5/10/2013 1:11:38 PM: 0499
Resident Date_Dim
5/10/2013 1:11:38
PM: Error: Table not found
5/10/2013 1:11:49 PM: 0503
Phy_Names:
5/10/2013 1:11:49 PM: 0504
5/10/2013 1:11:49 PM: 0505
LOAD %ISSP_Physician_Dim_Id,
5/10/2013 1:11:49 PM: 0506
Physician_Name as Physician_Names,
5/10/2013 1:11:49 PM:
0507 _PDRP_Flag as _pdrp_Flag
5/10/2013 1:11:49 PM:
0508
5/10/2013 1:11:49 PM: 0509
Resident Physician_Dim
----------------------------------------------------------------
The same thing is working fine in another environment.
Log file contents:
5/11/2013 12:18:55 AM:
0488 Max_Weekend_Date:
5/11/2013 12:18:55 AM:
0489 LOAD %ISSP_Date_Dim_Id as Date_ID
5/11/2013 12:18:55 AM:
0490
5/11/2013 12:18:55 AM:
0491 Resident Phyn_Rx_Weekly_Fact
5/11/2013 12:18:55
AM:
1 fields found: Date_ID,
2,870,400 lines fetched
5/11/2013 12:18:59 AM:
0493 inner Join
5/11/2013 12:18:59 AM:
0494
5/11/2013 12:18:59 AM:
0495 LOAD
5/11/2013 12:18:59 AM:
0496 Week_End_Date as Ims_Week_Code ,
5/11/2013 12:18:59 AM:
0497 %ISSP_Date_Dim_Id as Date_ID
5/11/2013 12:18:59 AM:
0498
5/11/2013 12:18:59 AM:
0499 Resident Date_Dim
5/11/2013 12:18:59
AM:
2 fields found: Ims_Week_Code,
Date_ID, 28,490 lines fetched
5/11/2013 12:18:59 AM: Joining/Keeping
5/11/2013 12:19:08 AM:
0503 Phy_Names:
5/11/2013 12:19:08 AM:
0504
5/11/2013 12:19:08 AM: 0505
LOAD %ISSP_Physician_Dim_Id,
5/11/2013 12:19:08 AM:
0506 Physician_Name as Physician_Names,
5/11/2013 12:19:08 AM:
0507 _PDRP_Flag as _pdrp_Flag
5/11/2013 12:19:08 AM:
0508
5/11/2013 12:19:08 AM:
0509 Resident Physician_Dim
--------------------------------------------------------
Kindly let me know why this unique behaviour is happening.
Thanx
Gauraw
