BTEQ?? Flad?? Mload??? which one is more prefarable

Tools
Enthusiast

BTEQ?? Flad?? Mload??? which one is more prefarable

Hi friends

can any one plz gestify my question?

Thanks and Regards
Anil Reddy
5 REPLIES
Enthusiast

Re: BTEQ?? Flad?? Mload??? which one is more prefarable

What is ur question?
Enthusiast

Re: BTEQ?? Flad?? Mload??? which one is more prefarable

What is ur question?
Enthusiast

Re: BTEQ?? Flad?? Mload??? which one is more prefarable

Hi friends
I'm asking that Fload and Mload are using for loading the data into data warehouse, is it?
which one is more prefarable for use?
and can we load data into warehouse using BTEQ?

Thanks and Regards
Anil Reddy

Enthusiast

Re: BTEQ?? Flad?? Mload??? which one is more prefarable

Hi Anil,

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.

If hope this clarifies your doubt.

Thanks,
Ravindra
Enthusiast

Re: BTEQ?? Flad?? Mload??? which one is more prefarable

Thank you very much you valuable information

Thanks and regards
Anil Reddy