I am working in a dataware house and few things are not clear to me that is why I wanna discus here.
For example, I have 10 MS Access files, and each of they have more than 5000658 number of rows, and data is in such a format like
Plz check attached image currentState.png
Whereas I have to import this large amount of data into MSSQL which can support large amount of data, where as MS access can support only up to 2 GB. And when I will import all of the data into MSSQL then total number of rows will be 50006580, then I have to do indexing to speed up database, otherwise it could take couple of mints for seaching.
But I thing before that I will do indexing I need to bring this data into the correct order otherwise end results will not be correct. And according to the my knowledge I need data in such a format like
Plz check attached image requireState.png
So now plz tell me that what to do in this situation how to bring data in correct format, so that it will give right answer when I will run quires in MSSQL.
Thank