Viewing 15 posts - 1,036 through 1,050 (of 3,060 total)
I'm in agreement with Ron in the sense that Business Requirements documentation is needed but I think poster is right when trying to get a proper picture of ETL mappings...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 4, 2011 at 5:57 am
I'm in agreement with Lutz.
Morevover - just out of curiosity, what are you planning to do with duplicate rows after the update process is done?
delete them?
keep them there forever?...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 4, 2011 at 5:48 am
programmersunlimited (6/3/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 3, 2011 at 3:26 pm
lgoolsby 86333 (6/3/2011)
IDXRaw and INVOICES. Both tables have fields INVNUM and MEASURE. IDXRaw will have multiple records with the same INVNUM and MEASURE values. ...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 3, 2011 at 3:18 pm
laurence 53118 (6/2/2011)
Thanks for your reply.
I know I have a long way to go but learning new stuff is rather fun and better than watching TV of an evening!
What...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 3, 2011 at 6:19 am
How big are those tables?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 2, 2011 at 6:01 am
Check t-sql related questions in this forum and attempt to solve the posted issues then, compare your solution whit the one proposed by senior members.
Threads usually include a good deal...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 2, 2011 at 5:58 am
Welcome to the wonderful world of RDBMS Harry.
First thing first, even when there is just one underlying relational theory implementations are different therefore you cannot expect to be fluent in...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 2, 2011 at 5:52 am
If - as it appears to be the case - you are not planning to add/update data into operational tables but fully populate them each time then proposed process may...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 1, 2011 at 4:23 pm
cw.izatt (6/1/2011)
also as a side note any suggestions on good SQL books for somebody in my situation?
Check BOL - Books On Line, it comes with SQL Server for free. If...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 1, 2011 at 4:17 pm
ShawnTherrien (5/30/2011)
PaulB-TheOneAndOnly (5/30/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 1, 2011 at 9:46 am
sdhan79 (3/3/2011)
Thank you for your input sir!
Just to add a level of complexity - real world is a complex environment and systems should reflect such a complexity; think about how...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 1, 2011 at 9:17 am
agustingarzon (5/31/2011)
I can't run the query against the base tables, provided the column names differ from table to table.
Yes you can, just write it. 🙂
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 1, 2011 at 9:03 am
highlord1 (6/1/2011)
Does Anyone know how to to this?
Yes. Use an inline view to check for non-existing rows a.k.a. the ones you want to insert.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 1, 2011 at 9:01 am
agustingarzon (5/31/2011)
SELECT * FROM [vwUnionAllFields] WHERE [MLNumber] = 123456
vwUnionAllFields is a...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 31, 2011 at 4:06 pm
Viewing 15 posts - 1,036 through 1,050 (of 3,060 total)