Recent Changes

Sunday, October 11

  1. page Eftpos Terminals edited ... Eftpos is a form of debit cards. Eftpos terminals are there to access the data from the the Ef…
    ...
    Eftpos is a form of debit cards. Eftpos terminals are there to access the data from the the Eftpos card and connect you to your bank account, so that you can pay for pretty much anything.
    Description
    ...
    have to cuntcount and give
    Explanation and application
    Eftpos terminals, like stated previously are used by the customer and buy the supermarket and many other shops to create a safe and private bank access for the customer to transfer the money from the customers account to the supermarkets account. The way a eftpos terminal does this is actually quite simple, the Eftpos card from the customer has a code and that code is unique to that card only, when that card is then swiped on the Eftpos terminal then the terminal uses that unique code to access the customers bank information creating a secure and private link, with that the customer then types in what bank account he wants to use (savings, cheque, etc.), then the customer has to simply punch in the pin code to validate and then the terminal transfers that money to the supermarkets bank account.
    (view changes)
    5:41 pm

Monday, December 8

Thursday, December 4

  1. page 00 Master List & Progress of Definitions edited ... Yes Open for commenting Data Warehouse Daniel L Yes Database Querying Daniel L Yes
    ...
    Yes
    Open for commenting
    Data Warehouse
    Daniel L
    Yes
    Database Querying
    Daniel L
    Yes

    (view changes)
    4:35 am

Sunday, November 30

  1. page ETL Process edited ... ETL is used for managing databases - extracting data from databases and make it ready to impor…
    ...
    ETL is used for managing databases - extracting data from databases and make it ready to import into a new or existing database.
    Description
    Please note that there is also ELT - Extract, Load, Transform - question: what is the difference and when would you use ELT in place of ETL?
    This following is from here.
    Extract, transform, load (ETL) refers to three separate functions combined into a single programming tool.
    (view changes)
  2. page ETL Process edited ... Extract, Transform, Load Definition ETL is used for managing databases - extracting data fr…
    ...
    Extract, Transform, Load
    Definition
    ETL is used for managing databases - extracting data from databases and make it ready to import into a new or existing database.
    Description
    This following is used for managing databases - extracting data from databases and make it ready to import into a new or existing database.here.
    Extract, transform, load (ETL) refers to three separate functions combined into a single programming tool.
    First, the extract function reads data from a specified source database and extracts a desired subset of data. For example in a supermarket, you may want to extract all the data of a customers and what they have purchased.
    ...
    with M.
    You might not need all the fields in the records extracted from the original source - for example you may not want to know the loyalty card number or the customer name/personal details.
    ...
    previously exist.
    ETL can be used to acquire a temporary subset of data for reports or other purposes, or a more permanent data set may be acquired for other purposes such as: the population of a data mart or data warehouse; conversion from one database type to another; and the migration of data from one database or platform to another.
    Explanation and application
    (view changes)
  3. page ETL Process edited ... Definition Description ... existing database. Extract, Extract, transform, load ...…
    ...
    Definition
    Description
    ...
    existing database.
    Extract,

    Extract,
    transform, load
    ...
    programming tool.
    First, the extract function reads data from a specified source database and extracts a desired subset of data. For example in a supermarket, you may want to extract all the data of a customers and what they have purchased.
    Next, the transform function works with the acquired data - using rules or lookup tables, or creating combinations with other data - to convert it to the desired state. For example the database that you want to import the data into may require the gender field to be 'M' or "F" but your data may be male or female. You therefore need to transform the data to the correct format - for example find all instances of Male in a particular field and replace with M.
    Finally, the load function is used to write the resulting data (either all of the subset or just the changes) to a target database, which may or may not previously exist. YouYou might not
    ...
    name/personal details.
    Finally, the load function is used to write the resulting data (either all of the subset or just the changes) to a target database, which may or may not previously exist.

    ETL can be used to acquire a temporary subset of data for reports or other purposes, or a more permanent data set may be acquired for other purposes such as: the population of a data mart or data warehouse; conversion from one database type to another; and the migration of data from one database or platform to another.
    Explanation and application
    (view changes)
  4. page ETL Process edited ... Definition Description This is used for managing databases - extracting data from databases…
    ...
    Definition
    Description
    This is used for managing databases - extracting data from databases and make it ready to import into a new or existing database.
    Extract, transform, load (ETL) refers to three separate functions combined into a single programming tool.
    First, the extract function reads data from a specified source database and extracts a desired subset of data. For example in a supermarket, you may want to extract all the data of a customers and what they have purchased.
    Next, the transform function works with the acquired data - using rules or lookup tables, or creating combinations with other data - to convert it to the desired state. For example the database that you want to import the data into may require the gender field to be 'M' or "F" but your data may be male or female. You therefore need to transform the data to the correct format - for example find all instances of Male in a particular field and replace with M.
    Finally, the load function is used to write the resulting data (either all of the subset or just the changes) to a target database, which may or may not previously exist. You might not need all the fields in the records extracted from the original source - for example you may not want to know the loyalty card number or the customer name/personal details.
    ETL can be used to acquire a temporary subset of data for reports or other purposes, or a more permanent data set may be acquired for other purposes such as: the population of a data mart or data warehouse; conversion from one database type to another; and the migration of data from one database or platform to another.

    Explanation and application
    Here is an extract from a googlebook on the ELT process:
    (view changes)

More