Inventory turn rate – How often you replenish inventory given its cost. The impact of this metric is to show efficiently inventory is managed. Dependent on the business, a low inventory turn rate can result in markdowns. For example, if…
Author: Steve
Quick way to approximate the RBA for a given SCN
While setting up GoldenGate, we wished there was a way to say “create extract myextract begin scn “, or something similar. However, there is no supported way to get this (of which I am aware at least, but would gladly…
Programatically creating GoldenGate conflict detection/resolution rules
We initially started with checking all columns in every table for any differences in an active-active environment, and aborting the replicat if it failed. That seems a bit over the top in hindsight, so we changed it to simply discard…
Comparing web content using python
We have an active/passive data center setup. We replicate the database data using GoldenGate, and maintain the application software through regular build processes. ATG publishing is included in the database data, and the targeter files are maintained via rsync. We…
Association rules in java
Assocation rules are a concept in which relationships between different elements of a common set can be established. For example, a study may be undertaken to determine the impact of one externally employed parent on childrens GPA in a household,…
Python implementation of luhn algorithm
The luhn algorithm, or mod 10, was developed by an IBM scientist in the 1950’s. To a large extent it is still used today to validate credit card numbers in front end applications. If you think back to your high…
Cost of Good Sold (COGS) and margins
This number represents what was spent in the direct production of goods for sale. For example, material used to produce clothing in a retail organization would fall in this category. Salaries for home office employees would not. If this number…
How does ATG calculate a checksum on a file asset
Here is how a checksum is calculated by ATG. This could be invaluable if you ever have to fix data. Get the checksum on the publishing agent filesystem… -bash-4.1$ pwd /opt/jboss/kits/current/atg_bootstrap.war/WEB-INF/ATG-INF/DAS/lib -bash-4.1$ java -cp classes.jar atg.core.io.CRC64 /tmp/MobileHomePageTargeter.properties Via Direct Table…
Python script to print blocking threads that are not blocked themselves
There are a lot of GUI tools to process the call stacks for a “thread dump” taken on a running JVM. This is just a command line tool to do it, which is normally where I start troubleshooting when there…
Oracle analytic functions continue to exhibit the coolness factor
Sorry, but I never grow tired of these. We wanted to know the average duration between an online shopper creating their cart and when they actually checked out. Analytic functions make this a snap. select min(gap), bucket from (select submitted_date…