Archive for the 'SQL/ETL' Category

Download Malaysia Postcode

While everyone is talking about fatwa on yoga , I’m here to share Malaysia postcode that I use to do some of my analysis work. (which I also get it from someone else. )
You will be expecting the file to be in this CSV format.

This is the only postcode list I have. If you [...]

Pentaho Data Integration - Introduction

Data is everywhere. I once heard someone saying that data is the next Intel Inside.Well, just look around and I think it’s very true indeed.
Pentaho Data Integration (PDI) is a powerful, metadata-driven ETL tool designed to bridge the gap between business and IT; Previously it’s known as Kettle (Kettle ETTL Environment).The best thing is: it’s [...]

MSSQL - Date Manipulating

By default, result for select getdate() in MS-SQL will be something like below:
getdate()
————————-
2008-09-09 15:01:47.340

CONVERT function can be use to manipulate the date format as per our need.
Using CONVERT:
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

example:
select CONVERT(varchar(25),getdate(),100)
————————-
Sep 9 2008 3:04PM
Below are the lists of style/format for reference :

AutoIT - Connecting to SQL Server.

Playing around with AutoIt take me to next level of coding. This time I need to automate a process where in a normal situation it will involve a few people to make the whole process completed.
One of the process need a connection to MS-SQL ,execute query and and get the results. As sharing is [...]


AWSOM Powered