Data collection and mapping
-
Hi All, I am looking for very efficient solution for this problem. Here is my problem description - I have serveral database, from which I have to pull data (All databases differ in physical design implementation), and insert them in standardized common database. Let me give you an example Database - 1 Table - 1 Col_1 - int Col_2 - text Col_3 - float Database - 2 Table - 2 Col_1 - int Col_2 - int Col_3 - float Col_4 - text Col_5 - text Common database col_1 (id) - int col_2 - int col_3 - float col_4 - text So mapping between database - 1 and common database would be col_1 --> col_2 col_2 --> col_4 col_3 --> col_3 and between database - 2 and commond database would be col_1 --> col_2 col_2 --> col_2 col_3 --> col_3 col_4 --> col_4 col_5 --> col_4 How can I achive this? One more thing, this mapping can be changed during runtime. Thanks, Ashish Patel
-
Hi All, I am looking for very efficient solution for this problem. Here is my problem description - I have serveral database, from which I have to pull data (All databases differ in physical design implementation), and insert them in standardized common database. Let me give you an example Database - 1 Table - 1 Col_1 - int Col_2 - text Col_3 - float Database - 2 Table - 2 Col_1 - int Col_2 - int Col_3 - float Col_4 - text Col_5 - text Common database col_1 (id) - int col_2 - int col_3 - float col_4 - text So mapping between database - 1 and common database would be col_1 --> col_2 col_2 --> col_4 col_3 --> col_3 and between database - 2 and commond database would be col_1 --> col_2 col_2 --> col_2 col_3 --> col_3 col_4 --> col_4 col_5 --> col_4 How can I achive this? One more thing, this mapping can be changed during runtime. Thanks, Ashish Patel
Well - for a start, you might want to try posting in only one forum. Go ahead, pick one.
Please visit http://www.readytogiveup.com/ and do something special today. Deja View - the feeling that you've seen this post before.