2. Bulk Loading from a Local File System Using COPY Command
8.1 هزار بار بازدید -
4 سال پیش
-
BULK LOADING FROM A LOCAL
BULK LOADING FROM A LOCAL FILE SYSTEM
Steps: To load CSV file.
1 Choosing a Stage for Local Files
2 Staging Data Files from a Local File System
3 Copying Data from an Internal Stage
Choosing a Stage for Local Files
Types of Stages
User Stages
Table Stages
Internal Named Stages
Creating a Stage ( Only for Internal Named Stages)
Staging Data Files from a Local File System
Staging the Data Files
Listing Staged Data Files
Copying Data from an Internal Stage
Loading Your Data
User Stage
Table Stage
Named Stage
Validating Your Data
Monitoring Files Staged Internally
Managing Data Files
Steps: To load CSV file.
1 Choosing a Stage for Local Files
2 Staging Data Files from a Local File System
3 Copying Data from an Internal Stage
Choosing a Stage for Local Files
Types of Stages
User Stages
Table Stages
Internal Named Stages
Creating a Stage ( Only for Internal Named Stages)
Staging Data Files from a Local File System
Staging the Data Files
Listing Staged Data Files
Copying Data from an Internal Stage
Loading Your Data
User Stage
Table Stage
Named Stage
Validating Your Data
Monitoring Files Staged Internally
Managing Data Files
4 سال پیش
در تاریخ 1399/10/03 منتشر شده
است.
8,181
بـار بازدید شده