Showing posts with label my. Show all posts
Showing posts with label my. Show all posts
Monday, March 2, 2015
Wetpaint 1 2 3 My Free Wiki Is Up!
- Link to Wetpaint
- Wetpaint Videos
WIKI?
A wiki is a type of website that anyone can easily edit and help grow through collaboration.
WETPAINT?
Is a 100% Free wiki (collaborative) authoring tool (it claims to be! Visit Professional Services and explore.), which enables anyone easily to start a free wiki that they can share with students, colleagues, friends, family, etc.
FEATURES?
Wetpaint is a reasonably easy-to-learn/use wiki tool, which has an amazingly attractive look-and-feel (subject to subjectivity!). Yeah, I can tell you also that this tool has an amazing list of features, and they are adding new features all the time (according to them), so theres always something new to try. Here are some of the juicy features:
- 1-2-3 Simple Site Creation
- Public or Private Sites
- Pre-Populated Templates (Classrooms, Group Projects, Gaming Clans, etc)
- Easy Photo/Video Integration
- Page Level Discussion Threads
- Customizable Page Templates
- Spell Check
- Menu of Popular Widgets
- Private Onsite Messaging
- Address Book Upload
- Site Statistics (Google Analytics and SiteMeter)
- RSS updates
- Email Notifications
- Etc.
Except for the annoying Google Ads (which is probably the main source of income for Wetpaint), floating toolbars, and the clipboard bug (minor fix needed!), this tool I believe is going to be a global Wiki smash hit soon. Dont ask me why! Just try it out for yourself :)
Wednesday, February 25, 2015
Kable MY Malaysias Premiere Instructional Technology Website
Kable.MY"This website provides the latest news, articles and tutorials on emerging technologies for educational purposes, and serves as a hub for educators to congregate and share ideas that can be put into practice. It is hoped that this website will be on the forefront of Malaysias instructional technology and inspire educators to use technologies to enhance their instructions."
NEW!
19 hours ago, I got a pleasant e-mail from Hafiz Hanif, who invited me to visit his new Kable.MY website. I was also invited to be a freelance writer for the website, but I told him instead of being a freelance writer, why not use whatever you like from ZaidLearn, and then link back to the original post (article). The reason is that whatever I write to share (to anyone), I will post it on ZaidLearn (First!). Anyway, this post is not about ZaidLearn, but about this awesome Kable.MY website that I just discovered, thanks to Hafiz Hanif.
Although, Kable.MY is still brand new, and probably needs some time to build up a substantial collection of awesome articles (unless they reuse with attribution and permission from great Edubloggers out there), I am really impressed with the website design, and the first few articles too are very useful and relevant.
INSPIRING!
Also, I like their teams learning philosophy and spirit:
"We are a bunch of normal educators like you, with the enthusiasm to provide the latest and fun ways to teach students, to inspire them with the use of technologies that are often regarded as a separate entity from our instructional strategies. Here, we share our thoughts on how to integrate technologies into your everyday teaching and learning activities, and how to understand the design of certain applications, how to re-purpose the applications to suit our educational needs, and how to get control over our own methodological strategies (Source)."
Yes, certainly a good start! The challenge is to keep that volcanic creative eruption continuously flowing, and if the passion and focus is there... WOW, this could evolve into something really special!
Thinking of it, after being inspired by Kable.MYs awesome website design, I believe it is time to relook and rethink the website design of ZaidLearn, which has not really changed much since its inception. But then again, neither has Googles homepage either. But, then again I have yet to find that swoosh factor that fits ZaidLearns flavor and content. One thing for sure, I would want the revamped website to infuse a lot of (white) dreaming space free from anything.
I believe it is time to erupt some changes soon...Need another 102 days to think about it!
Kable.MY, thanks for this inspiring website, and hopefully it will inspire more educators in Malaysia to share their learning stories and tips. Yes, why not :)
Sunday, February 15, 2015
My first learning example in Kettle An example is reproduced from Pentaho Tutorials Topic Filtering Rows
Hi Guys,
Here is my first learning experience with Kettle Community ETL.
Download Kettle from : Click Me
Sources to get start with Kettle :
1) http://wiki.pentaho.com/display/EAI/Getting+Started
2) http://localhost:8080/pentaho/docs/InformationMap.html
3) http://wiki.pentaho.com/display/EAI/Pentaho+Data+Integration+%28Kettle%29+Tutorial
You should have installed java in your local machine and path, java_home, jre_home set for it.
Below topic is a re-production of Kettle Transformation & Job example from Pentaho Tutorials and the description is slightly differ from the actual description.
Lets look at simple basics and then well jump into 1st example.
# What is Transformation in Kettle ?
# What are jobs in Kettle ?
# Core difference b/w Transformation & Jobs in Kettle ?
# Extensions for transformations & jobs in Kettle ?
# What are steps & hops ?
1) What is the usage of Transformation ?
Transformations are used to describe the data flows for ETL such as reading from a source, transforming data and
loading it into a target location.
2) Jobs
Jobs are used to coordinate ETL activities such as
Defining the flow and dependencies for what order transformations should be run
Preparing for execution by checking conditions such as, "Is my source file available?," or "Does a table exist?"
Performing bulk load database operations
File Management such as posting or retrieving files using FTP, copying files and deleting files
Sending success or failure notifications through email
3)Whats the difference between transformations and jobs?
Transformations are about moving and transforming rows from source to target. Jobs are more about high level flow control: executing transformations, sending mails on failure, ftping files
4) Extensions for transformations & jobs in Kettle ?
Transformation : .ktr
Jobs : .kjb
5) What are steps & hops ?
TOPIC :
Load sales data into a database. Several of the customer records are missing postal codes(zip codes) that must be resolved before loading into the database.
You will be given two .csv files to load the data into database.
The first file is : sales_data.csv and later one is Zipssortedbycitystate.csv
( Location of the files : /home/sada/softwares installed/Pentaho/data-integration/samples/transformations/files
)
In short , there is a column called "postalcode" in sales_data.csv with missing postal codes(i.e., the values are null) and need to fill the missed the missed postal codes using "postalcode" column of Zipsortedbycitystate.csv file.
Explanation :
The Final Transformation looks as shown in below :
The final job looks as shown in below(doing job is optional for this topic)
Transformation is divided into below sub tasks.
1) Retrieve Data From Flat File ( i.e., Retrieve Data From "sales_data.csv")
2) Filtering the records ( from the source file get only not null valued rows for "postal code").
3) Load to into Relational database ( Total Number of rows in this 2747)
4) Retrieve Data From your look-up file.
5) Resolve Missing zip information.
Download the example : Click Me
NOTE : While running the .ktr file (or .kjb file) in your environment you should specify the flat files(.csv files) location as per your folder structure.
#: Ive taken postgresql as output table.
Thank you.
Sadakar
BI developer.
(Pentaho/Jasper/Talend/Kettle).
:-)
Here is my first learning experience with Kettle Community ETL.
Download Kettle from : Click Me
Sources to get start with Kettle :
1) http://wiki.pentaho.com/display/EAI/Getting+Started
2) http://localhost:8080/pentaho/docs/InformationMap.html
3) http://wiki.pentaho.com/display/EAI/Pentaho+Data+Integration+%28Kettle%29+Tutorial
You should have installed java in your local machine and path, java_home, jre_home set for it.
Below topic is a re-production of Kettle Transformation & Job example from Pentaho Tutorials and the description is slightly differ from the actual description.
Lets look at simple basics and then well jump into 1st example.
# What is Transformation in Kettle ?
# What are jobs in Kettle ?
# Core difference b/w Transformation & Jobs in Kettle ?
# Extensions for transformations & jobs in Kettle ?
# What are steps & hops ?
1) What is the usage of Transformation ?
Transformations are used to describe the data flows for ETL such as reading from a source, transforming data and
loading it into a target location.
2) Jobs
Jobs are used to coordinate ETL activities such as
Defining the flow and dependencies for what order transformations should be run
Preparing for execution by checking conditions such as, "Is my source file available?," or "Does a table exist?"
Performing bulk load database operations
File Management such as posting or retrieving files using FTP, copying files and deleting files
Sending success or failure notifications through email
3)Whats the difference between transformations and jobs?
Transformations are about moving and transforming rows from source to target. Jobs are more about high level flow control: executing transformations, sending mails on failure, ftping files
4) Extensions for transformations & jobs in Kettle ?
Transformation : .ktr
Jobs : .kjb
5) What are steps & hops ?
- A transformation is a network of logical tasks called steps.
- Transformations are essentially data flows.
- The transformation is, in essence, a directed graph of a logical set of data transformation configurations.
- Steps are the building blocks of a transformation,
- for example a text file input or a table output.
- There are over 140 steps available in Pentaho Data Integration and they are grouped according to function; for example, input, output, scripting, and so on.
- Each step in a transformation is designed to perform a specific task, such as reading data from a flat file, filtering rows, and logging to a database
- Steps can be configured to perform the tasks you require.
- Hops are data pathways that connect steps together and allow schema metadata to pass from one step to another.
- Hops determine the flow of data through the steps not necessarily the sequence in which they run.
- When you run a transformation, each step starts up in its own thread and pushes and passes data.
TOPIC :
Load sales data into a database. Several of the customer records are missing postal codes(zip codes) that must be resolved before loading into the database.
You will be given two .csv files to load the data into database.
The first file is : sales_data.csv and later one is Zipssortedbycitystate.csv
( Location of the files : /home/sada/softwares installed/Pentaho/data-integration/samples/transformations/files
)
In short , there is a column called "postalcode" in sales_data.csv with missing postal codes(i.e., the values are null) and need to fill the missed the missed postal codes using "postalcode" column of Zipsortedbycitystate.csv file.
Explanation :
The Final Transformation looks as shown in below :
The final job looks as shown in below(doing job is optional for this topic)
Transformation is divided into below sub tasks.
1) Retrieve Data From Flat File ( i.e., Retrieve Data From "sales_data.csv")
2) Filtering the records ( from the source file get only not null valued rows for "postal code").
3) Load to into Relational database ( Total Number of rows in this 2747)
4) Retrieve Data From your look-up file.
5) Resolve Missing zip information.
Download the example : Click Me
NOTE : While running the .ktr file (or .kjb file) in your environment you should specify the flat files(.csv files) location as per your folder structure.
#: Ive taken postgresql as output table.
Thank you.
Sadakar
BI developer.
(Pentaho/Jasper/Talend/Kettle).
:-)
Subscribe to:
Posts (Atom)