- Details – Duration 15 to 20 minutes
- Data is available in local file system
/data/retail_db - Source directories:
/data/retail_db/ordersand/data/retail_db/customers - Source delimiter: comma (“,”)
- Source Columns – orders – order_id, order_date, order_customer_id, order_status
- Source Columns – customers – customer_id, customer_fname, customer_lname and many more
- Get the customers who have not placed any orders, sorted by customer_lname and then customer_fname
- Target Columns: customer_lname, customer_fname
- Number of files – 1
- Target Directory:
/user/<YOUR_USER_ID>/solutions/solutions02/inactive_customers - Target File Format: TEXT
- Target Delimiter: comma (“,”)
- Compression: N/A
- Data is available in local file system
- Validation