Adding Data to an Empty Data Source - trillium_discovery - trillium_quality - Latest

After you copy metadata to a new, empty (dynamic) data source, follow this procedure to add data to it.

To load data into an empty data source

1. On the navigation menu under Data Discovery, click View Data Sources. The data sources available in the repository are displayed.
2. Select an empty data source row with this icon .
3. On the top-right, click the Load Data button.
4. From the dropdown list, select one of the following options:

   Option	Description
   Change Data Source Options	With this option, you change the data source and the sampling settings:
   	Data Source: keep the original source or click Edit () icon and choose a new data source. Note: Only a data source with the same connection as the original data source can be selected.
   	Configure: keep the original setting or specify data sampling parameters. The Load all rows option is default selection. Select Load sample rows to specify if you want to sample first set of rows or random rows.
   	(Optional) SQL Where Clause: if you are loading data from a relational data source (DB2, Oracle, or ODBC-compliant database), you have the option to selectively retrieve data by defining an SQL Where clause. For information, see Filtering Relational Database Data. Schedule Job: select Now to run or select Later to pick a data to schedule the job.
   Load Data	Loads the data into the repository with original settings specified when the data source was created.

5. Click Load to start the job.
6. When the job completes, open a List View of the new data source and verify the data loaded correctly.
7. If expected attributes do not display, open the Choose Columns window (right-click a column title and select Choose Columns) and move any hidden columns into the Displayed fields list.