March 31, 2012 at 7:22 am
Hello All,
I have a task to write stored procedure for a data migration project, I am trying to load data from existing tables to a dimension table for warehousing ....
The challenge is I have to get the same number of incidents in the base table cos ..the dimension table being used is to have a vehicle per incident, and its damaged area ..which 1377 incidents records
where i encountered challenges i when i made a join to an incident_vehicle damage area to see the parts of the vehicles that has been damaged , at this point the challenge began cos i did a left join to the vehicle damaged area from the incident table, and in turn to a lookup/reference table to see what part of the vehicle that has been damaged per vehicle but i got about 20,000 records ...
My boss advised i concatenated each part of the columns recorded for the damaged area to fetch one vehicle per incidence
Please this might be theory but your advice is greatly needed....Many thanks
I know i can count on u guys as i am on a strict deadline
many thanks
November 30, 2012 at 4:26 am
col1 col2 col3
5.0 6.0 3.5
9.5 9.8 6.3
9.0 6.0 8.0
Col4 col5 col6
9.5 6.0 8.0
6.3 9.3 3.9
8.7 8.0 8.8
9.0 8.3 6.9
8.6 9.0 6.2
I have data like this in excel, how to load into 2 different tables
first table contain col1,col2,col3 as columns
second table contain Col4,col5,col6 as columns.
Plz help me how to do it...
November 30, 2012 at 4:34 am
raghavender.2369 (11/30/2012)
col1 col2 col35.0 6.0 3.5
9.5 9.8 6.3
9.0 6.0 8.0
Col4 col5 col6
9.5 6.0 8.0
6.3 9.3 3.9
8.7 8.0 8.8
9.0 8.3 6.9
8.6 9.0 6.2
I have data like this in excel, how to load into 2 different tables
first table contain col1,col2,col3 as columns
second table contain Col4,col5,col6 as columns.
Plz help me how to do it...
Do not hijack other peoples threads, you have already created your own thread here, please be patient, we are all unpaid volunteers who help in our spare time.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply