#DateForumTypeThreadPost
4311 Sep 2014 @ 12:45 PDTToolsReplyHow to find the number of columns in each table in Teradata ??Select tablename, count(Columnname) from dbc.tables where table_neme='MYTABLE' and Database='MYDATABASE' group by MYTABLE
4211 Sep 2014 @ 12:43 PDTToolsTopicHow to find the number of columns in each table in Teradata ??
4108 Sep 2014 @ 07:16 PDTDatabaseTopicHow can we connect (Different Oracle, Teradata) multiple database servers to join the tables from both DB's Can any one answer my Question...How can we connect (Different Oracle, Teradata) multiple database servers to join the tables from both DB's
4008 Sep 2014 @ 07:11 PDTDatabaseTopicHow do I convert a date or timestamp to a string in TeradataIn our database we have a system-generated ID that is built off of the timestamp. It’s not a date or time format, it’s a string, like (20130405103422), which is essentially the year, mo...
3906 Sep 2014 @ 10:45 PDTDatabaseReplyTERADATA UTILITIES Useful Information Q/A Basic & Expert levels How to skip the header row in the fastload script   RECORD 2; /* this skips first record in the source file */ DEFINE ...
3806 Sep 2014 @ 10:45 PDTDatabaseReplyTERADATA UTILITIES Useful Information Q/A Basic & Expert levels Why Fload doesn’t support multiset table in Teradata?   Fload does not support Multiset table because of restart capability.   Say, the fastload job fails. Till t...
3706 Sep 2014 @ 10:44 PDTDatabaseReplyTERADATA UTILITIES Useful Information Q/A Basic & Expert levels How to Skip or Get first and Last Record from Flat File through MultiLoad in Teradata?   In .IMPORT command in Mload we have a option to give record no. from which processing should...
3606 Sep 2014 @ 10:44 PDTDatabaseReplyTERADATA UTILITIES Useful Information Q/A Basic & Expert levels Which is faster – MultiLoad delete or Delete command in Teradata?   MultiLoad delete is faster than normal Delete command, since the deletion happens in data blocks of 64Kbyte...
3506 Sep 2014 @ 10:44 PDTDatabaseReplyTERADATA UTILITIES Useful Information Q/A Basic & Expert levels Different phases of MultiLoad in Teradata?   • Preliminary phase • DML phase • Acquisition phase • Application phase • End phase
3406 Sep 2014 @ 10:44 PDTDatabaseReplyTERADATA UTILITIES Useful Information Q/A Basic & Expert levels Difference between MultiLoad and TPump in Teradata?   Tpump provides an alternative to MultiLoad for low volume batch maintenance of large databases under control of a Teradata syst...
3306 Sep 2014 @ 10:43 PDTDatabaseReplyTERADATA UTILITIES Useful Information Q/A Basic & Expert levels How to make sure BTEQ utility is not erroring out while dropping a table when the table doesnt exist in Teradata?   Setting the error level to 0 will achieve this. ERRORLEVEL (3...
3206 Sep 2014 @ 10:43 PDTDatabaseReplyTERADATA UTILITIES Useful Information Q/A Basic & Expert levels   How do you transfer large amount of data in Teradata?   Transferring of large amount of data can be done by using the various Teradata Utilities i.e. BTEQ, FASTLOAD, MULT...
3106 Sep 2014 @ 10:43 PDTDatabaseReplyTERADATA UTILITIES Useful Information Q/A Basic & Expert levels Explain TPUMP (Teradata Parallel Data Pump) Utility in Teradata?   •TPUMP allows near real time updates from Transactional Systems into the Data Warehouse.It can perform Insert...
3006 Sep 2014 @ 10:42 PDTDatabaseReplyTERADATA UTILITIES Useful Information Q/A Basic & Expert levels Explain Multi Load in Teradata?   Used for loading, updating or deleting data to and from populated tables, typically with batch inputs from a host file.Cannot process tables define...
2906 Sep 2014 @ 10:41 PDTDatabaseTopicTERADATA UTILITIES Useful Information Q/A Basic & Expert levels Explain Fast Load in Teradata?   Loads large amount of data from external file into an empty table at high speed.Only load one empty table with 1 fast load job.Tables defined with R...
2806 Sep 2014 @ 10:31 PDTDatabaseReplyTeradata Useful Information Q/A for freshers and Expert Levels What are the types of HASH functions used in teradata?   These are the types of HASH, HASHROW, HASHAMP and HASHBAKAMP. Their SQL functions are- HASHROW (column(s)) HASHBUCKE...
2706 Sep 2014 @ 10:31 PDTDatabaseReplyTeradata Useful Information Q/A for freshers and Expert Levels What is the difference between User and database in Teradata?   - User is a database with password but database cannot have password - Both can contain Tables , views and macros...
2606 Sep 2014 @ 10:31 PDTDatabaseReplyTeradata Useful Information Q/A for freshers and Expert Levels Why does varchar occupy 2 extra bytes?   The two bytes are for the number of bytes for the binary length of the field. It stores the exact no of characters stored in varchar
2506 Sep 2014 @ 10:31 PDTDatabaseReplyTeradata Useful Information Q/A for freshers and Expert Levels What is spool space and when running a job if it reached the maximum spool space how you solve the problem in Teradata?   Spool space is the space which is required by the query for pr...
2406 Sep 2014 @ 10:30 PDTDatabaseReplyTeradata Useful Information Q/A for freshers and Expert Levels What is the difference between TIMESTAMP (0) and TIMESTAMP (6) in teradata?   Both has the Date and Time Values. The major difference is that TIMESTAMP (6) has microsecond too.
2306 Sep 2014 @ 10:30 PDTDatabaseReplyTeradata Useful Information Q/A for freshers and Expert Levels Which is more efficient GROUP BY or DISTINCT to find duplicates in Teradata?   With more duplicates GROUP BY is more efficient while if we have fewer duplicates the DISTINCT is efficie...
2206 Sep 2014 @ 10:30 PDTDatabaseReplyTeradata Useful Information Q/A for freshers and Expert Levels How to find the duplicate rows in the table in Teradata?   Group by those fields and add a count greater than 1 condition for those columns For example – SELECT name, ...
2106 Sep 2014 @ 10:29 PDTDatabaseReplyTeradata Useful Information Q/A for freshers and Expert Levels How to create a table with an existing structure of another table with or without data and also with stats defined in Teradata?   CREATE TABLE new_TABLE AS old_TABLE WITH DATA C...
2006 Sep 2014 @ 10:29 PDTDatabaseReplyTeradata Useful Information Q/A for freshers and Expert Levels Can you compress a column which is already present in table using ALTER in Teradata?   No,   We cannot use ALTER command to compress the existing columns in the table. ...
1906 Sep 2014 @ 10:29 PDTDatabaseReplyTeradata Useful Information Q/A for freshers and Expert LevelsWhat does” Pseudo Table” Locks mean in EXPLAIN Plan in Teradata?   It is a false lock which is applied on the table to prevent  two users from getting conflicting loc...

Pages