Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am on page 73 and I am loading data according to the steps in the book. The book loads lesser rows than me. Why ?
My load results -
Main Data << Flight Data (qvd optimized) 1,256,075 lines fetched
Carrier Groups << Carrier Groups (qvd optimized) 8 lines fetched
Airlines << Airlines (qvd optimized) 1,548 lines fetched
Carrier Operating Region << Carrier Operating Region (qvd optimized) 6 lines fetched
Flight Types << Flight Types (qvd optimized) 4 lines fetched
Aircraft Groups << Aircraft Groups (qvd optimized) 10 lines fetched
Aircraft Types << Aircraft Types (qvd optimized) 379 lines fetched
Distance Groups << Distance Groups (qvd optimized) 25 lines fetched
Connecting to Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\QlikView Development\Airline Operations\Data Files\MDBs\Dimension Tables.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False
Connected
Origin Airports 6,209 lines fetched
Destination Airports 6,209 lines fetched
Book load results -
Hi John
Your data is right if u see the access file in which Destination and Origin Airports have 6209 Rows. Might be it's error in the book when they are testing that app then they have only 2104 and 2169 rows.
Hi John
Your data is right if u see the access file in which Destination and Origin Airports have 6209 Rows. Might be it's error in the book when they are testing that app then they have only 2104 and 2169 rows.
Thanks. Yes, I checked it. My output is correct. I don't know why they have these differences.