Home > Examples > Tranformations > Credit Cards 

Sample Data Transformation Graphs.

Clover packs so many punches, it is sometimes easier to show than explain. Click on the tabs below to see some selected examples.

 

Data Load Credit Cards Web Service Email Validation Web Site Log Company Checks

Click the image to enlarge it. The sample images show annotated transformation graphs.

   Web Site Access Log

Credit Card Fraud Detection

This graph shows how credit card transactions are checked to detect suspicious transactions. The following steps are performed

  • Customer transactions are read in

  • These are merged with customer details from another source

  • Current exchange rates are fetched from a banking web page in the web

  • All transactions are then rebased to a base currency

  • The transaction is then split into 3 output streams a) bad or missing customer numbers b) incorrect currency data c) suspiciously high transactions

  • Each output stream is written to an HTML web page with the output data correcly populating the page using an HTML template

Related Points of Interest

  • HTML data written using the "Structured Data Writer" component

  • Will process 1 million transactions merged with 50,000 customers in 12 seconds (on a MacBook Pro laptop)

  • CTL used to perform small customized coding within the data transformation in one component

  • Demonstrates sorting, joining, filtering, mapping and data aggregation