Page Comparison

Click the Register data using file link.

On the Add Dataset dialog, provide a Name for the file.

For AWS-based deployments, select the name of your S3 Bucket from the list.

Select the file. Click the Actions menu (...) to navigate to the file.

Specify the File Type such as Character Separated Values, Parquet, or Sequence.

Specify the line separator, field separator, escape characters, enclosed by, skip top lines, and encoding type options.
See the Created dataset settings table section for details.

For Compression, select None or LZO.

If the data includes header information, select Contains Header Row so that the column headings will not be included as part of the data.

Select Ignore Empty Rows to have empty rows ignored.

Select Key as Column to set the field name to be the column description or select File name as column to set the file name to the column description.

If the source data contains primary key or foreign key, the system automatically marks it.

To use this file for lookup purposes, select the Lookup file checkbox. See Using lookup to learn more.

Click Preview to preview your data.

Click Add to add the file.

From the Database drop-down list, select the data source. The databases available in the data source are listed. 

Click the Choose tables as datasource link. The tables available in the database are listed. 

Click the Add Table link corresponding to the table that you want to add to your analysis.
For example, we have selected the ssb database and corresponding tables.

You can mark tables as Dimensions or Facts also.

You can also use Filters to filter data and columns from your tables.

From the Added table list, click the table and the corresponding column name to define Column Properties.

You can Hide columns, select Primary Key and Foreign Key, change Field name, and define the format for data here.
If the source data contains primary key or foreign key, the system automatically marks it.

Optionally, you can use the incremental identifier checkbox to specify the column you want to use to identify and process new data during an incremental  buildJob. The data should be sorted on this column or a date column.

Click the Register data using SQL query link.

On the SQL editor, enter your SQL query and click Preview to verify your data.

As you enter text, suggested statements, functions, operators, and so on, are displayed. Click the item to auto-fill it.

1. Use the Undo and Redo icons as needed as you create your calculated expression.

2. To find or replace content, click the Find/Replace icon, and enter what to find.

3. Select Match Case if needed.

4. If you want to replace the found value, enter the text to replace and specify whether to replace all.

5. To delete the entry for that item, click the X at the end of the line.

6. Click the Next button. The system validates all your files and tables and displays errors if your data is invalid.

7. The Define Relationships tab page is displayed with a set of relationships automatically created by the system.
   These relationships are created on the basis of data selected in the previous step and information about master data, fact data, primary key, and foreign key.

8. If the system does not generate any relationships, or to define your custom relationships, you can manually define relationships. For this, click the Add Relationship link.