<?xml version='1.0'?>
create table T7RTQ22AEOP000 nologging as
select distinct a12.CUST_CITY_ID CUST_CITY_ID,
a13.CALL_CTR_ID CALL_CTR_ID,
a11.QUARTER_ID QUARTER_ID
from LU_MONTH a11
join CITY_MNTH_SLS a12
on (a11.MONTH_ID = a12.MONTH_ID)
join CITY_CTR_SLS a13
on (a12.CUST_CITY_ID = a13.CUST_CITY_ID)
...
select pa14.YEAR_ID YEAR_ID,
avg((a11.TOT_COST - a13.TOT_COST)) WJXBFS1
from QTR_CATEGORY_SLS a11
join T7RTQ22AEOP000 pa12
on (a11.QUARTER_ID = pa12.QUARTER_ID)
join CITY_CTR_SLS a13
on (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and
pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
join TCM8D230MOP001 pa14
on (a11.QUARTER_ID = pa14.QUARTER_ID)
group by pa14.YEAR_ID
...
Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203Enterprise Manager 10.xData Load IssuesTo better understand the problem, please provide us with the following information: | <?xml version='1.0'?>
create table T7RTQ22AEOP000 nologging as
select distinct a12.CUST_CITY_ID CUST_CITY_ID,
a13.CALL_CTR_ID CALL_CTR_ID,
a11.QUARTER_ID QUARTER_ID
from LU_MONTH a11
join CITY_MNTH_SLS a12
on (a11.MONTH_ID = a12.MONTH_ID)
join CITY_CTR_SLS a13
on (a12.CUST_CITY_ID = a13.CUST_CITY_ID)
...
select pa14.YEAR_ID YEAR_ID,
avg((a11.TOT_COST - a13.TOT_COST)) WJXBFS1
from QTR_CATEGORY_SLS a11
join T7RTQ22AEOP000 pa12
on (a11.QUARTER_ID = pa12.QUARTER_ID)
join CITY_CTR_SLS a13
on (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and
pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
join TCM8D230MOP001 pa14
on (a11.QUARTER_ID = pa14.QUARTER_ID)
group by pa14.YEAR_ID
...
Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203Enterprise Manager 10.xData Load IssuesTo better understand the problem, please provide us with the following information: |
|
|
| |
|
|
|
|
| |
|
|
KB438968