Tag: databases

FROM

Columns defined by expression

WHERE

Both b & c

True

False

No more than 1 data type conversion is allowed per column during the Fastload

If an AMP is down FL cannot be restarted untill that AMP is back online

only load 1 empty table with one fast load job

Fast load assembles data in 64K blocks and then loads it using mutltiple sessions

Fast load supports triggers.

Fast Load

Multi Load

Tpump

Fast Export

Target table should not be created in the script

target table should be created in the script

Error tables should not be dropped in the script

Checkpoint should be declared in the script

Target table should not be dropped in the script

It is possible to stipulate how many updates may occur per minute

It is possible to have tpump running in the background all the time and just control its flow rate

It can load upto 60 tables at a time if using a single source

It can be stopped any time and all locks dropped or released with no ill consequences.

it uses macro to run the SQL statements

It has more error tollerance than FL and ML

DELETE statements only

UPDATE, DELETE, INSERT and SELECT statements

UPDATE statements only

INSERT statements only

INSERT Projects VALUES ('Content Development', 'Website content development project')

SAVE INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

INSERT INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

INSERT Projects ('Content Development', 'Website content development project')

ASC

DESC

No Default value

Returns error

SELECT FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

SELECT * FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

SELECT FROM Sales WHERE Date BETWEEN ('10/12/2005', '01/01/2006')

All the above