THIS THREAD IS CLOSED TO NEW COMMENTS. Please post questions in a new topic.
Teradata Developer Exchange is now hosting all the Teradata-related technical discussion forums. These forums are replacing the previous legacy Teradata discussion forums, but if you cannot find an answer to a topic here, please search the previous forums before posting.
Who can post here? Any registered user. But we have a few guidelines for you.
If you have feedback on the new forums, you can respond to this topic, or post a new topic into the General forum. Please enjoy the new forums, and remember: work hard, be nice, have fun!
Are all of the "legacy" forums being moved here? Or only some of them?
Only the technical "legacy" forums are being hosted here. Some non-technical forums will continue to be hosted at the
previous location. These include:
- Marketing Tips and CRM Best Practices
- PARTNERS 2009
DevX Platform Architect
There has been some discussion on why there are no direct equivalents to these legacy forums:
- Teradata Advanced Analytics User Group
- Data Warehousing
The short answer is that there doesn't appear to be enough differentiation between those forums and the Database forum. Many of the topics posted in those forums are not particular to "Advanced Analytics" or "Data Warehousing". We also posted a topic into those forums last week asking for opinion on whether these legacy forums were needed, and nobody requested that we keep them. That said, if at some point down the line we find that there's value in re-instating them, then we can easily do so.
Any plans to move the content of the old forums over to this forum.
We're investigating the feasibility of doing this, and it's certainly something we'd like to do. However, the timeline, if feasible, is weeks-months from now.
I have a question on how to check for the end of a file in cursor processing in a stored procedure. I have two cursors and I am checking for sqlstate = 00000 for successful processing but I need to know when one of the cursors hits end of file before the other. Would I declare 2 saved fields and stored the value after each fetch? Is it a simple set saved_sqlstate = sqlstate after each fetch? I can't find any documenation on this. I don't know if this is where I ask my question so if not, could you please redirect me? Thank you.
@Cheryl: this is the wrong thread for that topic... try creating a new topic in the Database forum: http://developer.teradata.com/forum/database
What about the old ATR does it move to this new forum ?
The ATR is still operating independently. We may investigate forum/mailing-list integration at some point, but not in the immediate future.
I think the old forum is more active than this one. The reminder thread over there about this new forum has gone down and new people coming there are not properly/promptly redirected to this forum.
I think moving everything here should be a better option. Or maybe closing new thread creation in the legacy forum and only allow replies to old threads.
There's been a few road bumps with integrating/retiring the old forums, but we're making progress on that, and this redundant situation should be over soon.
I'm glad to report that we're making some progress on the forum integration. Watch this space.
Regarding the technical "legacy" forums, when will they be retired (officially moved to forums.teradata.com)? Will we be redirected to this site?
Also, will "The TeradataForum" at http://www.teradataforum.com/index.htm be moved to forums.teradata.com?
@cyclinsue: the intention is to retire the 'legacy' forums this quarter, possibly in February. Users will then be directed to this site.
> Also, will "The TeradataForum" at http://www.teradataforum.com/index.htm be moved to forums.teradata.com?
No, as that is not a Teradata-operated site.
I am getting an error "Create UDF user- password too short" when installing the Teradata express edition 13.0 and the installation was rolling back. I have WIN XP-Sp3 installed on my system. Please help.
2 sec ago
i want to merge the results of many rows including duplicate values to one row.for example like consider column empid
i want output as 100,200,400,100,500,200......n
@MiBer, @sreesi: Please post UDF-related topics in the Extensibility forum.
@swati: Please post general SQL questions in the Database forum.
I have a teradata ODBC source and I am trying to connect to it using
the Teradata SQL assisstanr ver 12.0.0.04 and I am getting a
"3749:Options Parcel information is invalid" error. This never used to happen earlier. Would somone be able to help resolve this issue? Thanks
@rrain: please post this in the Connectivity forum.
Sorry this is my first time and I hope this is the right place to post this. I had installed Teradata Express on my laptop running Windows XP Pro and the files are store on an external drive. Unfortunately my external drive was corrupted and unreadable. I need to uninstall the old copy and reinstall a new copy. When I attempted to unistall the database, it could not find the xxx program. What is the best way to do the reinstall? What Tag should I use for this posting?
Q: Can anyone describe that how we can find the Data change frequency in table or column?
Example: I have a table with 5 columns and suppose 100 rows in my table next day i have added the 10 rows again next day i have added 10 rows and again next day i have delete the 5 rows or update 5 rows then finally how we can find that what is the data change frequency in table in respect of percentage?
Note: Based on this percentage we need to collect stats on table or column.
I have just registered to Teradata forum and very new. If my question is posted under wrong section sincere apologies.
In one of our current project data is extracted from 1200 source tables (Residing on Oracle 10G), data is extracted using Oracle Data_Pump + PLSQL into a dump file (.dmp or .exp) and imported into Oracle Target 1200 tables using Oracle PLSQL. Just an overnight CDC from source. No transformation of Data.
We do have intentions to move our Target across to Teradata. When this happens,
Question: Can Teradata utilities read contents from Oracle (.dmp or .exp) file which is binary format in import data to target tables residing on Teradata?
@Kris_Kaza: please create a new topic in the Database forum.
@thakurrabikant: Again, please post in the database forum.
@AndrewChing: please post this in the Database or Cloud Computing forum.
What are Major Differences Between Teradata V2R6 and Teradata 12.0 can someone please let me know.
Thanks and Regards,
Hi All...just joined this forum.
silent installation of teradata client ( teraGSS, tdicu and cliv2) on NT.
Can some one tell me how to do the silent installation of teradata client ( teraGSS, tdicu and cliv2) on NT?
What are Major Differences Between Teradata 12.0 and previous versions??? please let me know.
in my quary having bottelnek problem ? but i hav collect the statistics and i give PI ,SI @ whtevr need to rectify this problem i did all but problem is not resolve wht i do @ how to solve it
Hi, I am Alex from USA just join this community need your welcome hope that i ll gain so much from here
hi every one, I am new to teradata right now i have installed teradata on my laptop with the help of vm ware my laptop configuration is 4GB ram(i have given 2GB for vmware), i had also installed linux with the help of vm ware now I want to install teradata on linux platform.Can any one help me out.please tell me steps how to install teradata on linux. where I can find the proper software,does my laptop support it........even a small help is very useful for me.
hai i am rajkumar working in IBM as a teradata professional.. i have a query...in oracle if user( not a admin) delete a table ...we can retrieve a table using flashback command as a normal user..my questions is there any command is there in teradata...thanks in advance
hello friends, now onwords we all are one. please share our guidelines
Want to know how you can get your head in the cloud
Join us for the Third Annual Cloud Slam'11 Conference
Exclusive Agenda Launched; available via http://www.cloudslam.org
See you in the Cloud!
I am trying to run a very simple query. I keep receiving syntax errors. I am at the Beginner level but under the gun to produce this query and manipulate the data. Please call me in the next few minutes if you can help - Cell - 832.731.2628 - Jeff. Any help is greatly appreciated. Thank you.
can any one give me what are the tools are uses in development process thank you in adavnce
I am trying to run a very simple query. I keep receiving syntax errors.i am importing the data from laptop but error is
error: Use IMPORT to open a file first before
trying to read from it.
insert into tduser.emp values(:empid,:deptno)
Can anyone help me out with the terradata DCM module as we are replacing it with our legacy DCM system...
my first question would be while testing the screens in it which screens are the most important in Replenishment and forecasting, allocation, Cpi etc...
A early would be appreciated.
why period data type is powerful in teradata 13.0 . can any one explain how will period data type will improve the performance in teradata 13.0 instead of using general columns with date data types .
I've a case function in stored procedure need to change teradata query.
CASE WHEN DB.T.JobCmpltdDtTm < DB.T.JobCmpltWndwEndDtTmCalc+1
WHEN db.T.JobCmpltdDtTm IS NULL
END AS Age
I'm new to this terdata developement......
I want to know the ans. of a simple Q...
Which component is part of Teradata's open architecture?
I just joined this forum and am hoping to learn and grow as time goes along. Please accept my apologies if this is the wrong forum, not quite sure where to post.
I tried to download the td-express-13.10.00.05-vm-4gb.zip file. It appears to be corrupt. I have a hp Compaq 8510p with Win 7 x64, and I am not sure which version is the right one.
I have an assignment to work with MVC compression, and would like to run the compression toolkits on my own environment before approaching the client. Which version would you recommend for my particular laptop?
Thank you very much in advance for your reply
Can any one give me the limitations on mload delete
I am new to teradata
can any one help please
can any one provide me the bteq script to load data from TD table to excel.
my requirement is that ... i have some data validation query and i need to run after each load.
so i want to capture result for each query in one excel but in different tab.
please help me out ...
i new with TeraData...
I'm using TeraData Express..
And when i'm trying to use multiload ultility, i got a problem
when i already define the logtable and then logon, i automatically out from the multiload tool.
Please help me out
How do I open all 4 panes in the main window of Teradata SQL Assistant namely the Query window, Answerset (results) window, a History window, and a window for Database Explorer.
I am currently facing issue in getting tablesizes for few tables .
This tables exists in database but i am not able to get its sizes by running query on dbc.tablesize.I get select output and also i get sel count but not tablesize.
Database version is 12.0
If anyone has come across this issue please let me know or Any ways to get .
@Dhananjay, please post this as a topic in the Database forum.
I just installed Teradata 13 Express for Windows. SQL Assistant is supposed to be part of the install but doesn't show up in Start->All Programs->(Anything having to do with Teradata). Is there an installation log file for Teradata 13 Express for Windows?
Hi I need fing the skewness of my database table along with the no.of rows in tables. my databse consist of 1000 table . please help me. send the replay for my mail firstname.lastname@example.org. thanks in advance
Can we use Translate & Replace functions in Teradata?
Hi one quick question why multiload does not support unique secondary index ? Please revert back me at earliest.
Thanks in advance,
How does one create a new forum?
I am planning to export the data in a Teradata table toa flat file in UNIX using BTEQ.
My expected output is a pure delimited file. '~' .( It is ok if the delimter is some thing else)
I tried exporting using the REPORT,INDICDATA,DATA,DIF mode.
But I did not get the data in the required format.
I need this output to be read by a shell script .
can somebody help
BTEQ doesn't support delimited output.
You have to export in report format and concat all columns in your select:
trim(col1) || '~' || trim(col2) || '~' || col3
And of course, you should post the question as a new topic in an appropiate forum.
0001 .LOGTABLE dwlogtable;
0002 .LOGON 127.0.0.1/dbc,;
**** 21:15:54 UTY8400 Teradata Database Release: 13.00.00.12
**** 21:15:54 UTY8400 Teradata Database Version: 13.00.00.12
**** 21:15:54 UTY8400 Default character set: ASCII
**** 21:15:54 UTY8400 Current RDBMS has interval support
**** 21:15:54 UTY8400 Current RDBMS has UDT support
**** 21:15:54 UTY8400 Maximum supported buffer size: 1M
**** 21:15:54 UTY8400 Data Encryption supported by RDBMS server
**** 21:15:54 UTY1008 RDBMS failure: 3524, The user does not have CREATE TABLE a
**** 21:15:54 UTY2410 Total processor time used = '0.171601 Seconds'
. Start : 21:15:53 - SUN DEC 25, 2011
. End : 21:15:54 - SUN DEC 25, 2011
. Highest return code encountered = '12'.
my login failled in mload,fload,fexp error was rdbms failure how to access to database please send me ur answer
I am able to run BTEQ from UNIX system but when i try to invoke FEXP, i am getting the below error--
0002 .logon cnewd/ml492p,;
**** 01:37:11 UTY8400 Teradata Database Release: 12.00.03.33
**** 01:37:11 UTY8400 Teradata Database Version: 12.00.03.46
**** 01:37:11 UTY8400 Default character set: ASCII
**** 01:37:11 UTY8400 Current RDBMS has UDT support
**** 01:37:11 UTY8400 Current RDBMS has Large Decimal support
**** 01:37:11 UTY8400 Maximum supported buffer size: 1M
**** 01:37:11 UTY8400 Data Encryption supported by RDBMS server
**** 01:37:11 UTY1008 RDBMS failure: 3524, The user does not have CREATE TABLE access to
**** 01:37:12 UTY2410 Total processor time used = '0.071625 Seconds'
. Start : 01:36:52 - THU DEC 29, 2011
. End : 01:37:12 - THU DEC 29, 2011
. Highest return code encountered = '12'.
Can anyone please help??
I am using Teradata Universal Connector V 13. It is UI based . I want to customize and configure it for sending and receiving events using Java API,
so that I can invoke it through Java code
Can anyone provide pointers on it.
Pls let me know how can I can a teradata SQL script from Unix Shell script..
Is there a way to achieve this.
This ought to be simple, yet I can't find it anywhere.
How can I tell SQL Assistant to look for a custom syntax file on a network drive?
The default is c:\program files\ncr\terdata sql assistant. This does not allow me to have one syntax file for all users. I would have to create a copy on each users c: drive and maintain each copy.
Please tell me there is a better way to do this.
I have an Error Code 2689 from FastLoad. I can't find the description of that error code. Where can get the description of that and other FastLoad error codes? I am looking through the documentation, but have not been able to locate it yet... Thanks!
In the documentation - Section Gerneral -> Messages
2689 Field is null for column defined as NOT
Explanation: This error occurs only when the input
parcel contains a null field that is not defined as nullable.
Generated By: MoveRow.
For Whom: End User.
Notes: This is caused by an incorrect input parcel.
Remedy: Verify that valid data was submitted from
the host computer.
Der Beginn aller Wissenschaften ist das Erstaunen, dass die Dinge sind, wie sie sind.-Aristoteles
Thank you for your help Ulrich! That is exactly what I was looking for.
iam new to Teradata iam running Mload script iam getting the below error can u help me?
= MultiLoad Utility Release MLOD.13.00.00.005 =
= Platform WIN32 =
= Copyright 1990-2009 Teradata Corporation. ALL RIGHTS RESERVED. =
**** 17:47:01 UTY2411 Processing start date: WED FEB 04, 2009
= Logon/Connection =
0001 .logon 127.0.0.1/user_siva,;
**** 17:47:01 UTY6214 Reminder: A .Logtable statement must be entered for a successful logon.
= Processing Control Statements =
0002 .logtable sivakumar.party33;
**** 17:47:02 UTY8400 Teradata Database Release: 13.00.00.12
**** 17:47:02 UTY8400 Teradata Database Version: 13.00.00.12
**** 17:47:02 UTY8400 Default character set: ASCII
**** 17:47:02 UTY8400 Current RDBMS has interval support
**** 17:47:02 UTY8400 Current RDBMS has UDT support
**** 17:47:02 UTY8400 Maximum supported buffer size: 1M
**** 17:47:02 UTY8400 Data Encryption supported by RDBMS server
**** 17:47:02 UTY1008 RDBMS failure: 3524, The user does not have CREATE TABLE access to
**** 17:47:02 UTY2410 Total processor time used = '0.453125 Seconds'
. Start : 17:47:01 - WED FEB 04, 2009
. End : 17:47:02 - WED FEB 04, 2009
. Highest return code encountered = '12'.
I am tring to load a variable length test file in Teradata using Fastload. I am using the Teradata Fastload 220.127.116.11 for Windows. The file is tab delimited.
I am using the SET RECORD VARTEXT "\t" command in the Fastload script but I get the following error:
**** 09:35:04 Field too large in vartext data record: 2, field:
It is not recognizing the tab delimiters in the file using "\t" in the SET RECORD VARTEXT command. What should I be using?
Hi Siva - Grant CREATE access to the user ID to carry out the operation in that database.
We recently moved to TD 13.
Have a web app we are upgrading the drivers on.Receiving an error loading up a reference table with a simple select
[Teradata JDBC Driver] [TeraJDBC 13.10.00.03] [Error 1077] [SQLState HY000] executeQuery() cannot be used when there is no result set expected; use executeUpdate() or execute()
The query runs fine in DBViz using the same JDBC JARs. Here’s the Java code piece in question:
StringBuffer stmtBuffer = new StringBuffer(); stmtBuffer.append(loadAppPropertiesSQL1);
stmt = jdbcObject.getCon().prepareStatement(stmtBuffer.toString());
rs = stmt.executeQuery();
The error would suggest that the JDBC driver is having trouble recognising the query as a SELECT. Here is the precise query trying to be executed:
The SQL statement is:
SELECT a.NAME,a.VAL FROM CM_ADW_RFRN_DEV_D.PROPERTIES_T a WHERE status = 'on' AND type_cd = 'APP'
Any idea ?
You are using a very old version of the Teradata JDBC Driver. You may have encountered a known problem in that old version -- JDBC DR 147087.
Please upgrade to the newest version of the Teradata JDBC Driver that is available here on Developer Exchange.
I have a newbie .i have interest to share importent matter....
I have been curious about Teradata 14.0 release. Can you please let me know if Teradata14.0 has released? And drom where can i download Teradata 14.0 server and client.
Thanking you in advance.
can anyone tell me where is the LINK to download for "TeraData SQL Assistant 3.xx"??
hey, also would like to know if you have the download link for teradata sql assistant ^^^
<a href="http://www.watchmoviesfreeonline.biz">free movies online</a>
Under the downloads tab:
There is an option for "Teradata Studio Express" which is the SQLA Java / Eclipse based version ... just a new name.
Can anyone help in writting a script in unix for the below requirement.
i have a list of teradata queries which i want to run from a unix script and store the outputs of different queries in different files.
I have installed TERADATA EXPRESS 12,
Can anyone please guide me how to create and connect to own database.
Thanks in advance.
Can anyone guide me how to find the Parent and child relationship between tables in teradata.
Make a BTEQ script and call that from Unix and Your BTEQ file will look like below-
.logon <Host id>/<User id>,<password>
and so on..
You will see an shortcut on your desktop "Teradata Service Control". Launch that and click the option "Start the Teradata".
Once Teradata is running, go to ODBC Administrator and create a new connection.
Use below details.
IP - 127.0.0.1, Username- DBC, Password - DBC
Connect to Teradata SQL Assistant using this new connection. You will get some database already created and you can create your own databases, users and other objects.
I have a requirement in teradata, In Storeprocedure my parameters are Month and year.
I need moth first date and month last date.
example: if month=02 and year=2012 then Start date=02/01/2012 and End date=02/29/2012.
Can any one help me in this please......
VAL_TYP_CD column values
I want to split six records based on above three column.
PGM_TRM_ID CST_ACCT_WRK_PKG_ID CST_ELEM_TRM_CD
1 10 20
I want output is:
1 10 20 hours
1 10 20 direct
1 10 20 'OVERHEAD'
1 10 20 'GA'
1 10 20 'FCOM'
1 10 20 'TOTAL'
Here is my delema:
As part of an automated system which builds a db, i have to be able to change session's default database to something that dynamicaaly comes fropm a table.
1-I know DATABASE command considered DDL and can not be run inside an SP.
2-Tried combination of Macro & SP : no luck ... dbc.sysexecsql() won't run inside the Macro(says it doesn't exist, even with fully qualified name addressing)
3-my very last line of defence is using dynamic sql, just to be able to dynamically point to different database objects. It's very ugly ....
Please don't say i can't do this or that, i already notified by Teradata PE zillion times ;O) . Any practical solution is appreciated in advanced !
Also, does anybody know what's the technical reason for not being able to change Database on the fly and within an scipt? Just too many/much restrictions in TD scripting, I can't believe an enterprise level product with this many years in the market is so basic and primitive from time to time. It feels like trying to write application with Assembly.
Thanks in advanced!
Teradata Consultant with Strong 5-7 years' experience as Developer with following skills
. Expert level work experience in a Teradata environment using TD12
. Expert level working experience using Teradata Utilities (BTEQ, Fast Load,
MultiLoad, FastExport, TPump)
. Expert level experience using Teradata Tools (SQL Assistant, PMON,
. Expert level performance tuning on Teradata
. Expert level knowledge of Teradata BTEQ scripts to implement business
. Experience on large multi terabytes data warehouses
. Expert level SQL skills
. Excellent communication skills
Thanks & Regards,
O: 909-581-9559 | F: 714.494.8043 |
Ana@ESolser.com | www.ESolser.com
This message may contain confidential and/or privileged information. If you
are not the addressee or authorized to receive this for the addressee, you
must not use, copy, disclose or take any action based on this message or any
information herein. If you have received this message in error, please
advise the sender immediately by reply e-mail and delete this message. Thank
you for your cooperation.
I need to calculate week in month no by useing below condition.
count(WEND) from D_CM_ACCT_CAL where D_CM_ACCT_CAL_DAY.WEND = D_CM_ACCT_CAL.WEND and D_CM_ACCT_CAL_DAY.PERIOD = D_CM_ACCT_CAL.PERIOD
D_CM_ACCT_CAL(Table by Week),D_CM_ACCT_CAL_DAY(Table by month) are calender tables.
D_CM_ACCT_CAL (sample data):
WDATE WSTART WEND PERIOD
1/3/1992 12/30/1991 1/5/1992 199201
12/30/1991 12/30/1991 1/5/1992 199201
1/1/1992 12/30/1991 1/5/1992 199201
1/18/1992 1/13/1992 1/19/1992 199201
1/22/1992 1/20/1992 1/26/1992 199201
1/24/1992 1/20/1992 1/26/1992 199201
2/2/1992 1/27/1992 2/2/1992 199201
WSTART WEND PERIOD
12/30/1991 0:00 1/5/1992 0:00 199,201
1/6/1992 0:00 1/12/1992 0:00 199,201
1/13/1992 0:00 1/19/1992 0:00 199,201
1/20/1992 0:00 1/26/1992 0:00 199,201
1/27/1992 0:00 2/2/1992 0:00 199,201
DTL_TBL_DT = 5/7/2012
CNT = 1131
ACCT_WEEK_NO = 2993
WEEK_IN_YR_NO = 20
WEEK_IN_MO_NO = 2
WSTART = 5/4/2012
WEND = 5/10/2012
MO_NBR = 5
MON_BEGIN_DATE = 4/27/2012 - This is the month begin date that 5/7/2012 belongs to
MON_END_DATE = 5/31/2012
PERIOD = 201205
MTD_HRS = 192
GFY = 2012
FYEAR = 2012
FMONTH = 2012M05
FQTR = 2012Q2
PRD_WK_IN_MO = 2012052
LAST_MO_STR_DT = 3/30/2012 - This is the previous month based on sysdate
LAST_MO_END_DT = 4/26/2012
LAST_3_STR_DT = 1/27/2012 - This is the previous 3 months based on sysdate
LAST_3_END_DT = 4/26/2012
CURR_YEAR = Y
CURR_MONTH = Y
CURR_WEEK = N
LAST_MO_FLG = N
LAST_3_FLG = N
ITD_FLG = N
Please help me
The columns in a Customer table are defined as:
acctid INTEGER NOT NULL
and the columns in a Trans table are defined as:
amount DECIMAL(8,2) NOT NULL
The values (where ? indicates NULL) for these columns are the following:
Customer table Trans table
acctid acctnm__ acctid amount
227638 Martin 220532 55.38
220794 Miko 227638 21.73
228326 Nelly 220794 34.14
224753 ? 228326 42.88
216893 Jackie 223961 20.74
The values in the amount column need to be presented in a report so that the column values look
like the following:
Which query provides the desired result?
A. SELECT amount
FROM Customer a LEFT JOIN Trans b
ON a.acctid = b.acctid
ORDER BY 1 DESC;
B. SELECT amount
WHERE a.acctid = b.acctid
C. SELECT amount
FROM Customer a RIGHT OUTER JOIN Trans b
D. SELECT amount
FROM Customer a
Please provide your expert advise and bit more information if possible on the below query?
CREATE TABLE table1_ppi (
column1 INTEGER NOT NULL
,column3 DATE FORMAT 'yyyy-mm-dd'
PRIMARY INDEX (column1)
PARTITION BY RANGE_N(column3
BETWEEN DATE '2002-01-01' AND DATE '2012-12-31' EACH INTERVAL '1' YEAR,
ALTER TABLE table1_ppi
MODIFY PRIMARY INDEX
DROP RANGE BETWEEN DATE '2002-01-01' AND DATE '2002-12-31'
EACH INTERVAL '1' YEAR;
What is an effect of the ALTER TABLE statement?
A. Rows of the dropped partition are deleted.
B. Rows of the NO RANGE partition are deleted.
C. Rows are moved from the dropped partition to the save table.
D. Rows are moved from the dropped partition to the NO RANGE partition.
Note: One advise was: C but kindly explain how it will be?.
A requirement exists to perform upsert processing against a partitioned table. You choose to execute a MERGE INTO instead of a UPDATE ELSE INSERT statement.
Which three restrictions on the UPDATE ELSE INSERT statement make the MERGE INTO
statement a better choice? (Choose three.)
A. The target table may be defined with multilevel partitioning.
B. UPDATE portion may not modify any of the partitioning columns.
C. All partitioning columns need to be in the UPDATE's WHERE clause.
D. INSERT portion must specify the same partition as the UPDATE portion.
Given the following CREATE TABLE statement:
CREATE SET TABLE SPA_APPT_AVAILABILITY
( SPA_ID INTEGER NOT NULL
,APPT_DATE DATE NOT NULL
,APPT_TIME CHAR(5) NOT NULL
,TREATMENT_ID INTEGER NOT NULL
,TREATMENT_NAME CHAR(50) NOT NULL
,AESTHETICIAN_ID INTEGER NOT NULL
,PRIMARY KEY (SPA_ID, APPT_DATE))
Which column(s) will be defined as the primary index?
C. SPA_ID, APPT_DATE
D. SPA_ID, TREATMENT_ID
Note: One of the Answer given was : D but didn't understand how it will be??
I don't know where you got these questions from, but why don't you try to solve them on your own (using the manuals and a TD Express)?
This would help you to gather more knowledge on Teradata instead of trying to memorize answers like a trained monkey.
Thanks Dieter, I am trying to find your email but couldn't get it. That's why I posted here.
Actually before I posted these questions I tried and got answers but my
answers are clashing with the answers given by the Question bank.
Ex: When I executed the following query , Out put came as C but they given as D. like that my other queries are clashing.
Whom do you believe?
Your first hand experience when you actuallly tried the CREATE or some braindumps or other dubious sources?
I am hiring for, Full Time Job Opportunity with "The leading Data warehousing and Enterprise Analytics product company"
No need to relocate 100% travel job across USA.
Need Citizens and GCs.