In this article you will learn how to create the External Table.
The database table used in this example is:
Note: Every row must have a unique ID column with the name PK_idRow.
- The AccountNumber column contains the account numbers for all the bank statements which are being stored in DataStoreDSX.
- The Active column contains Yes for active bank accounts and No for dormant bank accounts.