Re: BTEQ?? Flad?? Mload??? which one is more prefarable
You can use FastLoad,MLoad or BTEQ to load data to DW based on the requirement.
FastLoad can load data from an input file to empty tables only.Its an highly efficient empty table load or Initial load. You can used only DML in fastload.
MLoad can load data from an input file to an empty table or table which is already populated. MLoad is efficient in maintaining the tables. You can use DML in Mload. You can do changes/updates to 5 tables(max) in a single MLoad.
Any general query can be run under BTEQ like . We can also create reports using BTEQ. We can also perform loading to tables using BTEQ but it is not efficient if we have more that million records.