Viewing 15 posts - 301 through 315 (of 3,060 total)
I'm not a fan of this kind of generic lookup tables - I would create a table for each one of the "codes" you have to describe.
Doing it properly e.g....
_____________________________________
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.April 30, 2012 at 7:24 am
rmechaber (4/30/2012)
PaulB-TheOneAndOnly (4/29/2012)
_____________________________________
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.April 30, 2012 at 6:39 am
GilaMonster (4/29/2012)
PaulB-TheOneAndOnly (4/29/2012)
eric.lyons (4/26/2012)
I wince every time I hear someone use the words "cloud computing".This is marketing hype in line with the "pet rock."
Hope you are trying crack a joke...
_____________________________________
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.April 29, 2012 at 4:04 pm
Express12 (4/27/2012)
TARGET:Oracle 11
COLUMN_1 char (14 Byte)
Data Value: 220490 ED
Any particular reason to use CHAR data type - which is deprecated - instead of using a proper number data type on...
_____________________________________
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.April 29, 2012 at 3:02 pm
eric.lyons (4/26/2012)
I wince every time I hear someone use the words "cloud computing".This is marketing hype in line with the "pet rock."
Hope you are trying crack a joke - which...
_____________________________________
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.April 29, 2012 at 2:51 pm
onlo (4/27/2012)
For those large companies, enterprises or governmental organizations, due to the data security issue, they will have their own private clouds.
This is incorrect. It is public information...
_____________________________________
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.April 29, 2012 at 2:49 pm
I see two very different questions here...
adc22 (4/29/2012)
1) How to check a trigger is fired or not, while doing database testing?
Welcome to the wonderful world of testing and quality...
_____________________________________
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.April 29, 2012 at 2:03 pm
ppcentral (4/27/2012)What you think?
Nice to see that for once Wikipedia got it right 😀
Seriously, I think you are focusing too much in meaningless formalities and too little in the task...
_____________________________________
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.April 29, 2012 at 1:56 pm
ppcentral (4/27/2012)
_____________________________________
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.April 27, 2012 at 5:57 am
Actually is pretty straight forward, rows in a Transactional Fact table have to show the level of detail of each and every "line" of the originating transactions.
If the originating transaction...
_____________________________________
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.April 26, 2012 at 3:30 pm
onlo (12/28/2009)
Cloud Computing - No need to have a DBA ?How do you think ?
A proper Cloud Computing provider doesn't goes beyond providing the basic platform usually in the form...
_____________________________________
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.April 26, 2012 at 12:25 pm
ppcentral (4/26/2012)
Today I post another issue related with Kimball Fact Table Types...
The following cases are two examples of Fact Tables in a dimensional model. Which Fact Table Type you...
_____________________________________
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.April 26, 2012 at 11:40 am
MaverickMan (4/25/2012)
Tools in discussions: Report Builder 3.0 would like to be...
_____________________________________
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.April 26, 2012 at 6:33 am
Spam - Reported
_____________________________________
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.April 25, 2012 at 6:14 am
:blink: 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.April 24, 2012 at 4:42 pm
Viewing 15 posts - 301 through 315 (of 3,060 total)