Monday, September 29, 2008

Teradata India - a sorry picture inside

Teradata is said to be the best back-end as far as MicroStrategy is concerned. Most of MSTR people I know, they have Teradata as the back-end. FYI, Walmart has the biggest implementation of MicroStrategy with more than 100 boxes of Teradata.

Now cut short to Teradata India, which is mainly involved in selling the Teradata boxes and then co-selling its consulting services (After all database requires some front-end to make use of it). My several freinds who are client side from Teradata have bitter experience. Teradata is just concerned about selling their boxes and letting employee "manage" things at client side of it own. Lots of people are working under duress.

They keep on advertising about MSTR position almost round the year but I fail to understand why their experience MSTR resources are working on different technology or worse on bench.

Last and the serious bomb. There is set targets for employees about Teradata certification. Obviously you need not pay for it. But, if you do not achieve it, you may get no raise at all. One of my friend's friend was so busy with the work (he did a great job) that it was impossible for him to remove time and do the certification. You get a bomb that there is no raise as you have not completed any certification.

If you are planning to join Teradata, do a good due diligence.

Sunday, September 21, 2008

Keys and Levels in MicroStrategy

Some notes and a tip:

Table keys
are the lowest level attributes in their respective hierarchies that are present in the logical table.

Fact entry levels are the lowest attribute levels at which a fact exists. The fact entry levels correspond to the lowest-level table key attributes for all the tables that define the fact.

A fact is only extended if a join does not exist between a fact table and the attribute to which the fact will extend to, i.e. the fact does not exist at the level of that attribute.

MicroStrategy SQL Generation Engine is sensitive to differences between its internal state and the states of metadata objects, there is a risk of SQL generation failures if schema modifications take place during normal user activity. In general, it is not recommended to perform schema updates during periods of normal or high usage. Schema changes should normally be reserved for periods of little to no user activity.

Saturday, September 06, 2008

3rd Compnay to purchase MicroStrategy in India

There are just two compnay taht use MicroStrategy. Wipro ePeripherals (Not Wipro Software) and Ashok Layland. Wipro license is of 7.2 and it is expired and they are not sure to purchase latest version of MicroStrategy. ALL is stil using MicroStrategy.

Now Pentaloon Retail is the latest purchasere of MicroStrategy and Mudra Garment is an unconfirmed buyer. I'll update the information as and when avaiable.