can we load 10 millions of records into target table by using
tpump?
yes we can load 10 millions of records into target table by
using tpump but it takes more time.y because it applies
rowhash lock on each row.,
>>generally less volume of data we go for tpump.,
>>if the table doen't have any limitations of fastload d
multiload then go for fastload.,
| Is This Answer Correct ? | 4 Yes | 0 No |
What do you mean by parsing?
What do you mean by teradata sql assistant?
How can we check the version of Teradata that we are using currently?
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
What type of indexing mechanism do we need to use for a typical data warehouse?
Give some points about Teradata Viewpoint ?
Steps to create a data model?
What is node? How many nodes and amps used in your previous project?
How can bottlenecks be identified?
What is basic teradata query language?
What are the commands to make a new table, change a table and remove a table in teradata?