1.what is Teradata?Teradata is basically an RDMS which is used to drive the Datamart, Datawarehouse, OLAP, OLTP, as well as DSS Appliances of the company. Some of the primary characteristics of Teradata are given below.
2.What are the newly developed features of Teradata?Some of the newly developed features of Teradata are: –
3.Highlight a few of the important components of Teradata.Some of the important components of Teradata are: –
4.Mention the procedure via which, we can run Teradata jobs in a UNIX environment
All you have to do is perform execution in UNIX in the way as mentioned below.
$Sh > BTEQ < [Script Path] > [Logfile Path] or $Sh > BTEQ < [Script Path] TEE [Logfile Path] 5.In Teradata, how do we Generate Sequence?In Teradata, we Generate Sequence by making use of Identity Column 6.During the Display time, how is the sequence generated by Teradata?All you have to do is use CSUM. 7.A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?The most suggestible utility here has to be Tpump. By making use of packet size decreasing or increasing, the traffic can be easily handled. 8.If Fast Load Script fails and only the error tables are made available to you, then how will you restart?There are basically two ways of restarting in this case.
9.Mention a few of the ETL tools that come under Teradata.Some of the ETL tools which are commonly used in Teradata are DataStage, Informatica, SSIS, etc. 10.Highlight a few of the advantages that ETL tools have over TD.Some of the advantages that ETL tools have over TD are: –
11.What is the meaning of Caching in Teradata?Caching is considered as an added advantage of using Teradata as it primarily works with the source which stays in the same order i.e. does not change on a frequent basis. At times, Cache is usually shared amongst applications. 12.How can we check the version of Teradata that we are using currently?Just give the command .SHOW VERSION. 13.Give a justifiable reason why Multi-load supports NUSI instead of USI.?The index sub-table row happens to be on the same Amp in the same way as the data row in NUSI. Thus, each Amp is operated separately and in a parallel manner. 14.How is MLOAD Client System restarted after execution?The script has to be submitted manually so that it can easily load the data from the checkpoint that comes last. 15.How is MLOAD Teradata Server restarted after execution?The process is basically carried out from the last known checkpoint, and once the data has been carried out after execution of MLOAD script, the server is restarted. 16.What is meant by a node?A node basically is termed as an assortment of components of hardware and software. Usually a server is referred to as a node. 17.Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?We need to use BTEQ Utility in order to do this task. Skip 20, as well as Repeat 60 will be used in the script. 18.Explain PDE.?PDE basically stands for Parallel Data Extension. PDE basically happens to be an interface layer of software present above the operation system and gives the database a chance to operate in a parallel milieu. 19.What is TPD?TPD basically stands for Trusted Parallel Database, and it basically works under PDE. Teradata happens to be a database that primarily works under PDE. This is the reason why Teradata is usually referred to as Trusted Parallel or Pure Parallel database. 20.What is meant by a Channel Driver?A channel driver is software that acts as a medium of communication between PEs and all the applications that are running on channels which are attached to the clients. |