Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 9 results for
dwh
- Page 1
Re: Help! my compaq laptop wont turn on
Hardware and Software
Microsoft Windows
16 Years Ago
by akyra83
… message...hundreds of these but with different number after "
DWH
" this time i wrote it down MISSING: \DEVICE\HARDDISKVOLUME1…
Re: Object reference not set to an instance of an object
Programming
Software Development
12 Years Ago
by user220
…; <add name="connstring" connectionString="Data Source=
DWH
;Initial Catalog=Test;Integrated Security=True"/> </connectionStrings…
DWH Data In Wrong Column
Programming
Databases
10 Years Ago
by shujat132
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 …
Re: DWH Data In Wrong Column
Programming
Databases
10 Years Ago
by LastMitch
>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. It's the weekend. I doubt if someone have MSSQL to test a query. What query do you have so far or what format are you trying to created. Any samples? Just to get an idea what you are …
Re: DWH Data In Wrong Column
Programming
Databases
10 Years Ago
by shujat132
to know about required format plz check attached image of table. and i am atucally working in data ware house.
Re: DWH Data In Wrong Column
Programming
Databases
10 Years Ago
by LastMitch
>to know about required format plz check attached image of table. and i am atucally working in data ware house. I don't understand your situation. I feel you are not asking or doing a query now but you want to know how to speed up the query meaning getting the data from the database quickly? Is that what you want to do?
Re: DWH Data In Wrong Column
Programming
Databases
10 Years Ago
by shujat132
dear brother actually i have explained it in first post, i know how to speed up query for that purpose i need to do proper indexing. for now, i want to actually data is misplaced in column like data of "Name" column is in "Address" or "Date" column. so i want to put data in their original column. to get better …
Re: DWH Data In Wrong Column
Programming
Databases
10 Years Ago
by JorgeM
I dont see how you are going to fix this programatically. I dont even see a pattern here. I know this sounds cray, but what I would do is export this into a spreadsheet (Excel) and try to group the rows into sections that "match" There should only be 5 groups because you have 5 columns. One of the groups is going to be correct. So …
Re: DWH Data In Wrong Column
Programming
Databases
10 Years Ago
by shujat132
Any other solution….? Because it’s quite difficult and lengthy and very soon I will have more records of 230 million number of rows. So I will not be able to so that much lengthy works. Can some body suggest me any better solution.
Search
Search
Forum Categories
Hardware/Software
Programming
Digital Media
Community Center
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Meet People
Forums
Top Members
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2024 DaniWeb® LLC