In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
what is the default character set in teradata,,?
What is a pseudo key? What is its use???
What's the difference between timestamp (0) and timestamp (6)?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the differences between TerdataV2R5 and V12 Versions please??
What is the maximum number of dml can be coded in a multiload script?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Highlight all the modes that are present under Confidence Level.
What's the syntax of sub string?
Can we collect statistics on multiple columns?
Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE
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