Randomizer Column Mapper Form

Accept Button

Returns current column mappings to the application that called the mapper form.

Cancel Button

Cancels any changes made to the column mappings and returns to the application that called the mapper form.

Erase All

Erases all the currently defined mappings. Randomizer Type, Randomizer Source and Random Value columns are blanked out.

Column Name

Field name given to the column in the data source table.

Data Type

Data type for the column. Data types are given in .NET System data types.

Randomizer Type

Drop-down list box from which you select the type of Randomizer to use.

Random Names And Locations

Person names, location names, demographic values.

See Random Names And Locations.

Random Names And Locations_2

Random Names And Locations_3

Random Names And Locations_4

Random Names And Locations_5

Used for including separate names and locations definitions in the same set of random data mappings.

For example:

Random Names And Locations might generate names for U.S. locations.

Random Names And Locations_2 might be generating names for Canada locations.

Random Names And Locations_3 might be generating female first names for New England locations only.

You can use the different random names and locations types to vary the values used in cases where a data source has multiple name fields that refer to different persons or companies.

Random Numbers

Number ranges, numeric offsets and sequences.

See Random Numbers for more information.

Random Strings

Random combinations of letters and numbers or syllables.

See Random Strings for more information.

Random Words

Random words, sentences or paragraphs.

See Random Words for more information.

Random Dates And Times

Ranges of dates, date offsets, date sequences.

Optionally add random times to the dates.

Express the dates as integers for data warehouse tables.

See Random Dates And Times for more information.

Random Booleans

Random True/False, 1/0 values.

See Random Booleans for more information.

Random Bytes

Random 8-bit Ascii or 16-bit Unicode bytes.

See Random Bytes for more information.

Random Data Elements

Full person names, first names, last names, business names, telephone numbers, email addresses, GUIDs.

See Random Data Elements for more information.

Custom Random Values

Sets of random values built from custom queries that you define using any relational data source.

For example, you could build a list of all products from a query that uses your company’s sales and product tables. The list will reflect the frequencies with which the products occur in your sales table.

See Custom Random Values for more information.