Teradata Interview Questions
Questions Answers Views Company eMail

How is Teradata in current market?

4 5406

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

IBM,

1 2970

what are the roles and responsibilities of teradata DBA ?

TCS,

1 23388




what are the day to day activities of teradata DBA ?

TCS,

4298

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 2187

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

Teradata,

4 8723

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

Wipro,

6 6818

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 6487




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 7276

what is sysdba and sysdbc ? which has high priority ?

Wipro,

2614

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

Wipro,

5 8034

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

Wipro,

1 4415

what is single value and Multivalue ?

IBM, Wipro,

1 3895

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 4418

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 5133


Post New Teradata Questions






Un-Answered Questions { Teradata }

how can we analyze the locks ?

965


what are the uses of fact table and dimension table in banking project?

3383


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

1055


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1123


what is object level locking ? where do appear this type of locking ?

2417






what is sysdba and sysdbc ? which has high priority ?

2614


Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

918


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

1650


if collect stats but it show low confidence why?

73


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

852


If a Node is busy what are the steps you can take to avoid ?

1217


If RDBMS is halted what will you do ?

1007


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

779


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

999


Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

882