Tag: databases
Questions Related to databases
-
It describe how to interpret the flat file and options to load the data.
-
It describe the location and format of the data file.
-
It describe the location of the Bad and Discard records file .
-
It has the control to connect database
-
LOAD DATA, INFILE, COLUMNS OF THE TARGET TABLE
-
BADFILE
-
DISCARDFILE
-
LOADING OPTIONS, FILE FORMATTER
-
The LOAD DATA statement is required at the beginning of the control file.
-
The INFILE option specifies where the input file is located
-
Specifying BADFILE, then bad records found during loading will be stored in this file.
-
Specifying DISCARDFILE , then records which do not meet a WHEN condition will be written to this file.
-
Field Seperator - how the fields are separated in input file.
Correct Option: A,B,C,D,E
-
The LOAD DATA statement is required at the beginning of the control file.
-
The INFILE option specifies where the input file is located
-
Specifying BADFILE, then bad records found during loading will be stored in this file.
-
Specifying DISCARDFILE , then records which do not meet a WHEN condition will be written to this file.
-
Field Seperator - how the fields are separated in input file.
Correct Option: A,B,C,D,E
-
INSERT
-
APPEND
-
REPLACE TRUNCATE
-
DELETE UPDATE
-
INSERT : Loads rows only if the target table is empty
-
APPEND: Load rows if the target table is empty or not.
-
REPLACE: First deletes all the rows in the existing table and then, load rows.
-
TRUNCATE: First truncates the table and then load rows.
-
Conventional
-
Direct
-
Indirect
-
Insert