Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

How is Teradata in current market?

4 8818

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

IBM,

1 4957

what are the roles and responsibilities of teradata DBA ?

TCS,

1 28120

what are the day to day activities of teradata DBA ?

TCS,

5816

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 3843

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

Teradata,

4 14157

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

Wipro,

6 11974

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 10336

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 13482

what is sysdba and sysdbc ? which has high priority ?

Wipro,

3827

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

Wipro,

5 13369

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

Wipro,

1 7012

what is single value and Multivalue ?

IBM, Wipro,

1 6342

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 7580

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 8755

Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the newly developed features of Teradata?

1018

What is teradata? What are some primary characteristics of teradata?

971

Explain the term 'foreign key' related to relational database management system?

1040

What is the syntax for case when statement?

1133

How to Extract data from multiple legacy systems?

1117

How to select first n records in teradata?

1101

What are the available primary index types in teradata.

1031

List the logical and conditional operators that are used with teradata along with their meanings?

1001

What are teradata utilities?

1108

What is the difference between fastload and multiload? Which one is faster?

1220

What are differences between teradata and ansi session modes in teradata?

1172

In Teradata, what is the significance of UPSERT command?

1228

What are aggregate tables? How do you design them using teradata?

1168

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?

1197

What is spool space? Why do you get spool space errors?

1015

For More Un-Answered { Teradata } Questions Click Here