in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance6 8884
suppose one Cylinder split data blocks are moved from where?1 2692
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: email@example.com
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
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. yedu my email-id: firstname.lastname@example.org@gmail.com1759
1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?6 43143
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR4 8165
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.1 2949
What is the difference between SI and JI?2 5011
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.4 9167
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.4 6797
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
how to delete duplicate records in multi set table without using any tables2 10972
Can you fastexport a field, which is primary key by putting equality on that key?
Explain the meaning of Amp?
what are the day to day activities of teradata DBA ?
What is the use of having index's on table?
What does sleep function does in fast load?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Differentiate primary key and partition key?
What happens when a node suffers a downfall?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Highlight the need for Performance Tuning.
What are the multiload utility limitations?
During the Display time, how is the sequence generated by Teradata?
Which is more efficient group by or distinct to find duplicates?
What is primary index and secondary index?
What are the scenarios in which full table scans occurs?