me,myself,english and programming..

Archive for June, 2008

Extract, Transform and Load (ETL) – Part 2

Monday, June 30th, 2008

I have been working on Data Warehousing in the Insurance Company for quite some time. Since 2001 to be exact. ETL is part of data warehouse component. My Introduction post about ETL is somewhere in 2006. Since then, so many things happened. I resign and come back again to the same company,doing the same thing. I’m not sure whether it is good or not but I enjoy doing my current job.

For my dear readers which is new with ETL,

ETL stands for extract, transform and load, the processes that enable companies to move data from multiple sources, reformat and cleanse it, and load it into another database, a data mart or a data warehouse for analysis, or on another operational system to support a business process.

Monitoring almost a thousand ETL job daily is not an easy job. Considering that a few problem might occured while running the jobs. Networking problem,source file not in proper format,database server down,database full,your SQL query getting so damn slow and many other things might occured.

(more…)

Blogger wanted at AirAsia

Monday, June 23rd, 2008

This might be interesting for blogger in Malaysia.Come on guys/gals…those yang interested why not give a try. :)

air asia job

I’m not sure what is the expected salary for that position.

For detail information :

http://www.airasia.com/site/my/bm/page.jsp?reference=jobsetc

Power Yoga – My Scorpion pose at last

Thursday, June 19th, 2008

Once upon a time in October 2007 last year, I had My first yoga class. Since then, I religiously attend my yoga class every monday after office hour (of course some time I need to skip the class due to 1001 reasons)

There are many different types of yoga and one of it,known as Power Yoga. This is what my instructor said when I ask what type of Yoga that I learn from him. Frankly, yoga look like simple but once you’ve done it you will know how tiring it is. Once, I happen to fall asleep while doing corpse pose. I wonder if you could imagine how tired I am. :)

Enough said, here is my version of scorpion pose.

hmm…I think, still need to improve the pose.

tn Image064

(more…)

How to sound smart, polished and confident

Tuesday, June 17th, 2008

To sound more intelligent

Speak just a bit slower to allow yourself to select the most appropriate words and to give the impression of thoughtfullness.

To sound more powerful

Use short,simple declarative sentences. Say what you mean and mean what you say.Cut out any useless connectors, adjectives,adverbs and superlatives.

To sound more polished

Never answer a question with a blunt “yes” or “no”. Append a short phrase of clarification. For example,”No I did not see that” or “Yes, I know Mary”

(more…)

Reveals your forgotten mdb password !

Monday, June 16th, 2008

Some of my friends asking about how to reveal protected access file (.mdb) due to some reasons, hence I write this post to help them. :)

Here you go.

Description
===========
This utility reveals the database password of every password-protected mdb file that created with Microsoft Access 95/97/2000/XP or with Jet Database Engine 3.0/4.0 .
It can be very useful if you forgot your Access Database password and you want to recover it.

Known Limitations
==============
* In Access 2000/XP files, this utility cannot recover passwords that contains more than 18 characters.
* This utility shows only the main database password. It cannot recover the user-level passwords.

accesspv

(more…)