80.2K

Verified Solution

Link Copied!

5.6 The same data can be provided to you in many different ways. Below are four extracts of the same data. The first extract is properly formatted for import into the company database. Notice, that this extract uses a pipe delimiter, puts each unique record on a different row, and uses text qualifiers of a single quote when commas are present. Your task is to discuss how to transform the other extracts so they can be imported into the company database. Required For each of the other three data extracts, do the following: . Describe if delimiters are present, and if so, what they are. Describe if text qualifiers are present, and if so, what they are. Describe the steps you would take to prepare each extract for importing into the company's database. Correct Format for Import PrimaryKey CustomerName CustomerAddress Description CreditLimit 1001 Camp-a-lot Corporation 2103 County Rd W #W, Seymour, WI, 54165' Buys mostly in summer 10000 1002 Outdoors Forever Inc. '3145, Lake Geneva, WI, 53147' New customer 5000 1003A11Pro Campingl '12303 233rd Ave, Trevor, WI, 53179'Wants confirmations by telephone, email, and maill'15,000 1994 Camping Extreme LLC|8153 W Holly Rd, Mequon, WI, 53097' ||7000 1005JD Camping Company | 9624 N Lamplighter In, Thiensville, WI, 53092 Sells goods on consignment |'10,000 1. Extract 1 PrimaryKey, CustomerName, CustomerAddress, Description, Creditlinit 1001, Camp-a-lot Corporation,2103 County Rd W #W, Seymour, WI, 54165,Buys mostly in summer, 10000 1002, Outdoors Forever Inc., 3145, Lake Geneva, WI, 53147, New customer, 5000 1003,A11Pro Camping, '12303 233rd Ave, Trevor, WI, 53179, Wants confirmations by telephone, email, and mail, 15,800 1004, Camping Extreme LLC,8153 W Holly Rd, Meguon, WI, 53097,7000 1005, JD Camping Company, 9624 N Lamplighter In, Thiensville, WI, 53092, Sells goods on consignment,10,000 2. Extract 2 5880 PrimaryKeyCustomerName CustomerAddress Description Creditlimit 1001Camp-a-lot Corporation "2103 County Rd W #W, Seymour, WI, 54165" Buys mostly in summer 18000 10020utdoors Forever Inc. "3145, Lake Geneva, WI, 53147" New customer 1003A11Pro Camping "12303 233rd Ave, Trevor, WI, 53179" Wants confirmations by telephone, email, and mail 1004Camping Extreme LLC "8153 W Holly Rd, Mequon, WI, 53097" 7000 100530 Camping Company"9624 N Lamplighter Ln, Thiensville, WI, 53092" Sells goods on consignment 10,000 15,000 3. Extract 3 PrimaryKey CustomerName CustomerAddress |Description CreditLimit 1001 Camp-a-lot Corporation '2103 County Rd W #W, Seymour, WI, 54165' |Buys mostly in summer|10000 1002 Outdoors Forever Inc. '3145, Lake Geneva, WI, 53147' New customer 5000 1003 AllPro Camping '12303 233rd Ave, Trevor, WI, 53179' Wants confirmations by 9 telephone, email, and mail|'15,000' 1004 Camping Extreme LLC '8153 W Holly Rd, Mequon, WI, 53097' || 7000 1005 JD Camping Company '9624 N Lamplighter Ln, Thiensville, WI, 53092' | Sells goods on consignment |'10,000' 5.6 The same data can be provided to you in many different ways. Below are four extracts of the same data. The first extract is properly formatted for import into the company database. Notice, that this extract uses a pipe delimiter, puts each unique record on a different row, and uses text qualifiers of a single quote when commas are present. Your task is to discuss how to transform the other extracts so they can be imported into the company database. Required For each of the other three data extracts, do the following: . Describe if delimiters are present, and if so, what they are. Describe if text qualifiers are present, and if so, what they are. Describe the steps you would take to prepare each extract for importing into the company's database. Correct Format for Import PrimaryKey CustomerName CustomerAddress Description CreditLimit 1001 Camp-a-lot Corporation 2103 County Rd W #W, Seymour, WI, 54165' Buys mostly in summer 10000 1002 Outdoors Forever Inc. '3145, Lake Geneva, WI, 53147' New customer 5000 1003A11Pro Campingl '12303 233rd Ave, Trevor, WI, 53179'Wants confirmations by telephone, email, and maill'15,000 1994 Camping Extreme LLC|8153 W Holly Rd, Mequon, WI, 53097' ||7000 1005JD Camping Company | 9624 N Lamplighter In, Thiensville, WI, 53092 Sells goods on consignment |'10,000 1. Extract 1 PrimaryKey, CustomerName, CustomerAddress, Description, Creditlinit 1001, Camp-a-lot Corporation,2103 County Rd W #W, Seymour, WI, 54165,Buys mostly in summer, 10000 1002, Outdoors Forever Inc., 3145, Lake Geneva, WI, 53147, New customer, 5000 1003,A11Pro Camping, '12303 233rd Ave, Trevor, WI, 53179, Wants confirmations by telephone, email, and mail, 15,800 1004, Camping Extreme LLC,8153 W Holly Rd, Meguon, WI, 53097,7000 1005, JD Camping Company, 9624 N Lamplighter In, Thiensville, WI, 53092, Sells goods on consignment,10,000 2. Extract 2 5880 PrimaryKeyCustomerName CustomerAddress Description Creditlimit 1001Camp-a-lot Corporation "2103 County Rd W #W, Seymour, WI, 54165" Buys mostly in summer 18000 10020utdoors Forever Inc. "3145, Lake Geneva, WI, 53147" New customer 1003A11Pro Camping "12303 233rd Ave, Trevor, WI, 53179" Wants confirmations by telephone, email, and mail 1004Camping Extreme LLC "8153 W Holly Rd, Mequon, WI, 53097" 7000 100530 Camping Company"9624 N Lamplighter Ln, Thiensville, WI, 53092" Sells goods on consignment 10,000 15,000 3. Extract 3 PrimaryKey CustomerName CustomerAddress |Description CreditLimit 1001 Camp-a-lot Corporation '2103 County Rd W #W, Seymour, WI, 54165' |Buys mostly in summer|10000 1002 Outdoors Forever Inc. '3145, Lake Geneva, WI, 53147' New customer 5000 1003 AllPro Camping '12303 233rd Ave, Trevor, WI, 53179' Wants confirmations by 9 telephone, email, and mail|'15,000' 1004 Camping Extreme LLC '8153 W Holly Rd, Mequon, WI, 53097' || 7000 1005 JD Camping Company '9624 N Lamplighter Ln, Thiensville, WI, 53092' | Sells goods on consignment |'10,000

Answer & Explanation Solved by verified expert

See Answer