Data Grid Header

The Data Grid in the BDB Data Preparation is used for visualizing the data. The data displayed in the grid is a sample from the actual data set or complete data based on the data volume. The grid always shows the first 10 K rows in the dataset.

The grid has a header that displays the column name and column type from the selected dataset.

Each Column Header has a Context Menu icon. The Context menu displays the Column Type, option to Delete the column, and option to Rename column.

It also presents the data type of the column. It is analyzed based on the max match to any data type in the first 10K records.

Consider that out of 10000 rows sample, there are 9000 integers and 1000 string values, the selected data type is Integer. The 1000 string rows get detected as invalid rows.

Pagination

Pagination is implemented for the grid data. The tool displays 20 records on each page.

Please Note: The maximum rows displayed for sampling is always 10k.

Data Types

The Data Grid header displays Data Types. Some of the supported Data Types are as given below:

1. Integer

2. Double

3. String

4. Date

5. Timestamp

6. Long

Please Note:

• The Data Preparation workspace supports more than the listed Data Types.

• The user can edit the name for the Data Preparation using the Title bar.