If you select the option to generate data by using profiling information; data will be generated using the boundaries derived from the profiling results. Click Next to continue.
REPLACE WITH THIS IMAGE: Images/Wizards/Generating Data with Profiling Information.png
- The following dialog allows you to manage ranges for the number of rows. Click Next to continue.
REPLACE WITH THIS IMAGE: Images/Wizards/Capturing Sample Data from Source Connection_1.png
Icons |
Description |
|---|---|
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png |
Click to Create range. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png |
Select a range and click to Edit range. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png |
Select a range and click to Delete range. |
- The Export sample data - Select the destination folder dialog allows you to set the column and record delimiters and to select the destination folder.
REPLACE WITH THIS IMAGE: Images/Wizards/Capturing Sample Data from Source Connection_2.png
Enter the following details:
Icons |
Description |
|---|---|
Delimited |
Choose between delimited and fixed width. |
Column delimiter |
Select one of the following from the drop-down list:
|
Record delimiter |
Select one of the following from the drop-down list:
|
Apply escape characters |
Apply escape characters to values defined by RFC 4180. Any " in a value is substituted by "". If the value contains a comma, carriage return or line feed the value is encapsulated in double quotes. |
Size escape characters |
Consider escape characters as part of the value, hence limiting the maximum length of the generated value. This is for instance required for MS SQL Server bulk load. |
Export folder |
Each entity becomes a CSV file with a name reflecting the entity. |
- Click Export to continue.