Patterns and Examples

What are Patterns?

Patterns are designs for controls, groups of controls, or portions of models that solve problems that recur in the solutions that PhixFlow implements. Put another way, Patterns are the bits of Models that are constantly re-used to solve problems that keep cropping up. There is no hard and fast rule for what constitutes a pattern, and some of the patterns listed here and in PhixFlow documentation and examples might seem very simple. There is also no such things as a definitive pattern list - new patterns can be added at any time. Employing these patterns and examples into PhixFlow models should help speed up model creation and development.

More extensive details on Patterns and Exercises is contained in PhixFlow's training documentation and phixflow users are encouraged to read and work through all training materials.

Data Collection and Comparison:

• Removing duplicates
• Comparing two files
• Comparing Expected Vs Actual filenames in a directory
• Creating web service collectors
• Binary file loading
• Inexact / Fuzzy matching

Using Multipliers:

• Turning a single record into multiple records
• Using Input Multipliers to insert values into the SQL Query of a DB Extractor
• Using Input Multipliers to break SQL "IN" clause into batches.
• Creating Unique indexes in PhixFlow
• Using InMemory Streams

PhixFlow Operational Features:

• Process Separate files into separate streams
• Using Concurrent Collectors
• Using Drill Down filters in lookups
• SQL Server Stream Sizing
• Oracle Server Stream Sizing

Other Patterns

• Data Enrichment Options : Loopback Lookup/Triangle pattern/Embedding fixed values in the query/merging directly from the DB.
• Managing a "Master List"
• General Ledger Reconciliation