If the table does not have duplicates then which utility you can suggest to lo

If the table does not have duplicates then which utility you
can suggest to load the data ?

Question Posted / narsingrao

3 Answers
6620 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If the table does not have duplicates then which utility you can suggest to load the data ?..

Hi,

>>If the table doesn't have any
duplicates(triggers,sp,ji,hi,nusi,usi) we go for fastload.

>>if the table data <1mill we go for bteq

Is This Answer Correct ?

5 Yes

1 No

If the table does not have duplicates then which utility you can suggest to load the data ?..

Answer / tdguy

If the table is empty and the amount of data to be loaded
is in millions, then, fload would be a better option.

Is This Answer Correct ?

4 Yes

0 No

If the table does not have duplicates then which utility you can suggest to load the data ?..

Answer / mallikahrjunarao rayidi

Fastload is better for unique rows loading

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Teradata Interview Questions

What are the functions involved in shared information architecture?

0 Answers

Explain parsing engine in teradata?

0 Answers

how to delete duplicate records in multi set table without using any tables

2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

6 Answers IBM,

How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale

1 Answers

What is the multi-insert?

0 Answers

what is meant by Hot amp?

2 Answers IBM, Satyam,

Can you load multiple data files for same target table using fastload?

1 Answers

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers

what is the difference between bpo and call centre?

2 Answers American Solutions,

Explain fallback in teradata?

0 Answers

Highlight a few of the advantages that ETL tools have over Teradata.

0 Answers

For more Teradata Interview Questions Click Here