-------------------------------------------------------- -- File created - Wednesday-April-05-2017 -------------------------------------------------------- -------------------------------------------------------- -- DDL for Table DIM_SPORT_TEAM -------------------------------------------------------- CREATE TABLE "DMS_SAMPLE_DW"."DIM_SPORT_TEAM" ( "SPORT_TEAM_ID" NUMBER(38,10), "SPORT_TEAM_NAME" VARCHAR2(30 BYTE), "SPORT_TEAM_ABBREVIATED_NAME" VARCHAR2(10 BYTE), "HOME_FIELD_ID" NUMBER(3,0), "SPORT_TYPE_NAME" VARCHAR2(15 BYTE), "SPORT_TYPE_DESCRIPTION" VARCHAR2(120 BYTE), "SPORT_LEAGUE_SHORT_NAME" VARCHAR2(10 BYTE), "SPORT_LEAGUE_LONG_NAME" VARCHAR2(60 BYTE), "SPORT_LEAGUE_DESCRIPTION" VARCHAR2(120 BYTE), "SPORT_DIVISION_SHORT_NAME" VARCHAR2(10 BYTE), "SPORT_DIVISION_LONG_NAME" VARCHAR2(60 BYTE), "SPORT_DIVISION_DESCRIPTION" VARCHAR2(120 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ; REM INSERTING into DMS_SAMPLE_DW.DIM_SPORT_TEAM SET DEFINE OFF; Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (291,'Tampa Bay Rays','TB',26,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL East','American League East','American League East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (81,'Boston Red Sox','BOS',10,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL East','American League East','American League East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (91,'Baltimore Orioles','BAL',19,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL East','American League East','American League East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (211,'Toronto Blue Jays','TOR',23,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL East','American League East','American League East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (241,'New York Yankees','NYY',30,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL East','American League East','American League East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (21,'Minnesota Twins','MIN',25,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL Central','American League Central','American League Central'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (31,'Chicago White Sox','CWS',28,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL Central','American League Central','American League Central'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (41,'Detroit Tigers','DET',7,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL Central','American League Central','American League Central'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (221,'Kansas City Royals','KC',13,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL Central','American League Central','American League Central'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (251,'Cleveland Indians','CLE',22,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL Central','American League Central','American League Central'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (51,'Oakland Athletics','OAK',18,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL West','American League West','American League West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (101,'Seattle Mariners','SEA',24,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL West','American League West','American League West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (141,'Houston Astros','HOU',16,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL West','American League West','American League West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (181,'Los Angeles Angels','LAA',1,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL West','American League West','American League West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (201,'Texas Rangers','TEX',11,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','AL West','American League West','American League West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (61,'Philadelphia Phillies','PHI',6,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL East','National League East','National League East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (121,'Washington Nationals','WSH',17,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL East','National League East','National League East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (131,'Miami Marlins','MIA',14,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL East','National League East','National League East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (231,'Atlanta Braves','ATL',27,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL East','National League East','National League East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (261,'New York Mets','NYM',5,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL East','National League East','National League East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (71,'Chicago Cubs','CHC',29,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL Central','National League Central','National League Central'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (151,'St. Louis Cardinals','STL',3,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL Central','National League Central','National League Central'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (161,'Cincinnati Reds','CIN',12,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL Central','National League Central','National League Central'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (171,'Milwaukee Brewers','MIL',15,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL Central','National League Central','National League Central'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (1,'Pittsburgh Pirates','PIT',21,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL Central','National League Central','National League Central'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (111,'San Diego Padres','SD',20,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL West','National League West','National League West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (191,'Los Angeles Dodgers','LAD',9,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL West','National League West','National League West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (271,'San Francisco Giants','SF',2,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL West','National League West','National League West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (281,'Arizona Diamondbacks','ARI',4,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL West','National League West','National League West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (11,'Colorado Rockies','COL',8,'baseball','A sport with 9 players, bats, and balls - what could possibly go wrong?','MLB','Major League Baseball','Professional baseball league in North America.','NL West','National League West','National League West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (381,'Buffalo Bills','BUF',43,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC East','American Football Conference East','American Football Conference East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (391,'Miami Dolphins','MIA',59,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC East','American Football Conference East','American Football Conference East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (401,'New England Patriots','NE',55,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC East','American Football Conference East','American Football Conference East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (411,'New York Jets','NYJ',34,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC East','American Football Conference East','American Football Conference East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (421,'Denver Broncos','DEN',39,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC West','American Football Conference West','American Football Conference West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (431,'Kansas City Chiefs','KC',38,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC West','American Football Conference West','American Football Conference West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (441,'Oakland Raiders','OAK',63,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC West','American Football Conference West','American Football Conference West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (451,'San Diego Chargers','SD',46,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC West','American Football Conference West','American Football Conference West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (301,'Baltimore Ravens','BAL',45,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC North','American Football Conference North','American Football Conference North'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (311,'Cincinnati Bengals','CIN',58,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC North','American Football Conference North','American Football Conference North'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (321,'Cleveland Browns','CLE',52,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC North','American Football Conference North','American Football Conference North'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (331,'Pittsburgh Steelers','PIT',50,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC North','American Football Conference North','American Football Conference North'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (341,'Houston Texans','HOU',42,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC South','American Football Conference South','American Football Conference South'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (351,'Indianapolis Colts','IND',54,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC South','American Football Conference South','American Football Conference South'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (361,'Jacksonville Jaguars','JAX',53,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC South','American Football Conference South','American Football Conference South'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (371,'Tennessee Titans','TEN',48,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','AFC South','American Football Conference South','American Football Conference South'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (541,'Dallas Cowboys','DAL',37,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC East','National Football Conference East','National Football Conference East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (551,'New York Giants','NYG',33,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC East','National Football Conference East','National Football Conference East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (561,'Philadelphia Eagles','PHI',47,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC East','National Football Conference East','National Football Conference East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (571,'Washington Redskins','WAS',35,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC East','National Football Conference East','National Football Conference East'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (611,'Seattle Seahawks','SEA',51,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC West','National Football Conference West','National Football Conference West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (581,'Arizona Cardinals','ARI',61,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC West','National Football Conference West','National Football Conference West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (591,'Los Angeles Rams','LA',32,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC West','National Football Conference West','National Football Conference West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (601,'San Francisco 49ers','SF',49,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC West','National Football Conference West','National Football Conference West'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (461,'Chicago Bears','CHI',62,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC North','National Football Conference North','National Football Conference North'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (471,'Detroit Lions','DET',60,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC North','National Football Conference North','National Football Conference North'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (481,'Green Bay Packers','GB',36,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC North','National Football Conference North','National Football Conference North'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (491,'Minnesota Vikings','MIN',56,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC North','National Football Conference North','National Football Conference North'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (501,'Atlanta Falcons','ATL',44,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC South','National Football Conference South','National Football Conference South'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (511,'Carolina Panthers','CAR',40,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC South','National Football Conference South','National Football Conference South'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (521,'New Orleans Saints','NO',41,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC South','National Football Conference South','National Football Conference South'); Insert into DMS_SAMPLE_DW.DIM_SPORT_TEAM (SPORT_TEAM_ID,SPORT_TEAM_NAME,SPORT_TEAM_ABBREVIATED_NAME,HOME_FIELD_ID,SPORT_TYPE_NAME,SPORT_TYPE_DESCRIPTION,SPORT_LEAGUE_SHORT_NAME,SPORT_LEAGUE_LONG_NAME,SPORT_LEAGUE_DESCRIPTION,SPORT_DIVISION_SHORT_NAME,SPORT_DIVISION_LONG_NAME,SPORT_DIVISION_DESCRIPTION) values (531,'Tampa Bay Buccaneers','TB',57,'football','Teams of 11 players attempt to move an oblong ball 100 yards while beating the snot out of each other.','NFL','National Footbal League','Professional football league in North America.','NFC South','National Football Conference South','National Football Conference South'); -------------------------------------------------------- -- DDL for Index DIM_SPORT_TEAM00054C5C494C5A88 -------------------------------------------------------- CREATE UNIQUE INDEX "DMS_SAMPLE_DW"."DIM_SPORT_TEAM00054C5C494C5A88" ON "DMS_SAMPLE_DW"."DIM_SPORT_TEAM" ("SPORT_TEAM_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ; -------------------------------------------------------- -- Constraints for Table DIM_SPORT_TEAM -------------------------------------------------------- ALTER TABLE "DMS_SAMPLE_DW"."DIM_SPORT_TEAM" ADD CONSTRAINT "DIM_SPORT_TEAM00054C5C494C5A88" PRIMARY KEY ("SPORT_TEAM_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "DMS_SAMPLE_DW"."DIM_SPORT_TEAM" MODIFY ("SPORT_DIVISION_SHORT_NAME" NOT NULL ENABLE); ALTER TABLE "DMS_SAMPLE_DW"."DIM_SPORT_TEAM" MODIFY ("SPORT_LEAGUE_LONG_NAME" NOT NULL ENABLE); ALTER TABLE "DMS_SAMPLE_DW"."DIM_SPORT_TEAM" MODIFY ("SPORT_LEAGUE_SHORT_NAME" NOT NULL ENABLE); ALTER TABLE "DMS_SAMPLE_DW"."DIM_SPORT_TEAM" MODIFY ("SPORT_TYPE_NAME" NOT NULL ENABLE); ALTER TABLE "DMS_SAMPLE_DW"."DIM_SPORT_TEAM" MODIFY ("SPORT_TEAM_NAME" NOT NULL ENABLE); ALTER TABLE "DMS_SAMPLE_DW"."DIM_SPORT_TEAM" MODIFY ("SPORT_TEAM_ID" NOT NULL ENABLE);