Teradata Interview Questions
Questions Answers Views Company eMail

How is Teradata in current market?

4 8114

Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???

IBM,

1 4506

what are the roles and responsibilities of teradata DBA ?

TCS,

1 27553

what are the day to day activities of teradata DBA ?

TCS,

5562

hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 3456

Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.

Teradata,

4 13211

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

Wipro,

6 10822

I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

IBM,

4 9514

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

JPMorgan Chase,

6 11848

what is sysdba and sysdbc ? which has high priority ?

Wipro,

3564

which utitility can use for loading the data from non-teradata to teradata ?

Wipro,

5 12299

what is differences between Fastload and Multiload as per DBA aspect ?

Wipro,

1 6387

what is single value and Multivalue ?

IBM, Wipro,

1 5751

Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

Wipro,

3 6909

I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

Wipro,

3 8044


Post New Teradata Questions

Un-Answered Questions { Teradata }

What is meant by Teradata Gateway?

794


What are the functions of a teradata dba?

786


What are the different functions performed in development phase?

812


Explain fallback in teradata?

789


what is sysdba and sysdbc ? which has high priority ?

3564


What is a dimension table?

798


How would you load a very large file in teradata in general?

782


What is the difference between teradata and oracle?

764


Explain teradata utilities?

746


how many modules are there in telecome domain?how to explain the architecture?

1768


What are the frequently used data types in teradata?

778


Highlight the points of differences between the database and user in Teradata.

794


Name the five phases that come under MultiLoad Utility.

757


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

819


What are the available primary index types in teradata.

768