All forum activity

#DateUserForumTypeThreadPost
5864221 Jul 2016 @ 12:57 PDTFredToolsReplyDetermine #sessions to set for load / exp jobsSteve's comment related to LOAD sessions. For EXPORT, the defaults (4, 4, 2) are generally fine. I would not change them.   Not sure what you mean by "not auto calculating". Th...
5864121 Jul 2016 @ 11:29 PDTFredToolsReplyHow read consistency is maintained during Teradata Fast ExportAs with a normal SQL SELECT, by default a READ lock would be applied at the beginning of the process. A locking modifier can be used, e.g. to downgrade to ACCESS lock (which does not maintain ...
5864021 Jul 2016 @ 11:28 PDTnamitapradhanDatabaseReplyTPT load in informatica giving CLI ErrorHi Amit, Did you get a resolution for this? We have started getting this issue for 2 of our sessions. On checking the trace files, we see the errors below **** 03:20:11 TPT10508: RDBMS error 263...
5863921 Jul 2016 @ 11:11 PDTau185006Teradata Database on AWSReplyAWS instance unreachable for Teradata Database Developer (Single Node)Thank you call for feedback,  redeployment of AMIs are under way to address this.
5863821 Jul 2016 @ 11:05 PDTindra91DatabaseReplyReal/DoublePrecision/FLoat type in TeradataThanks Fred.So we can define a column as float in Teradata but it is not possible to define a column with data type as REAL?Is the understanding correct?
5863721 Jul 2016 @ 11:00 PDTFredDatabaseReplyReal/DoublePrecision/FLoat type in TeradataREAL and DOUBLE PRECISION are ANSI standard syntax, interpreted as identical to Teradata FLOAT.
5863621 Jul 2016 @ 10:53 PDTdnoethDatabaseReplyEquivalent function for DATEADDWhat's the datatype of orig_ord_dt_tm, does it include WITH TIME ZONE? This returns exactly what you did in SQL Server: orig_ord_dt_tm - INTERVAL '7' HOUR You might also get a...
5863521 Jul 2016 @ 10:43 PDTindra91DatabaseTopicReal/DoublePrecision/FLoat type in TeradataIn the reference of Teradata I could see numeric data types like Real,Double Precision,Float.But I could see example of only Float data.Can anybody point out whether all the three refers to the sam...
5863421 Jul 2016 @ 10:35 PDTindra91ToolsTopicHow read consistency is maintained during Teradata Fast ExportHi guys, I would like to know how read consistency is managed by teradata Fast Export.When it tries to read data from the database does it automatically request for rows on the table before the ex...
5863321 Jul 2016 @ 10:02 PDTmcalleja74DatabaseReplyEquivalent function for DATEADDHello, Our database automatically defaults to GMT time and when we used SQL Server, we had to minus -7 hours for arizona time. The function in SQL we use to do was dateadd(HH,-7, orig_ord_dt_tm) ...
5863221 Jul 2016 @ 09:01 PDTsachin.sebastianDatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousRefer to this thread http://forums.teradata.com/forum/database/consolidate-rows
5863121 Jul 2016 @ 08:07 PDTdnoethDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GBWhen you succeed to upgrade SLES to 11.2 Teradata will not start because SLES 11.1 is a dependency  :-)
5863021 Jul 2016 @ 07:19 PDTjuanalfonsoDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GB Hello again, Thanks for the answers but, apparently, SAP DS works in Linux too. In fact, I have the software for the installation. I've read that the Product Availability Matrix post...
5862921 Jul 2016 @ 06:53 PDTMadhumDatabaseTopic free text columnsHi All,   We are getting requirements to add a list of free text  columns from ODS to a table in Teradata  Potentially that will result in 5-6 columns of type varhcar(2000) or ...
5862821 Jul 2016 @ 06:15 PDTzakywAnalyticsReplyQUERY IN ASTER Ya , i have account aster and the configure has been completed but , i confused about the query because is different with query in teradata for example function LIKE. , maybe you have references fo...
5862721 Jul 2016 @ 05:42 PDTM.Saeed KhurramDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GBYes, I agree with Johannes, You can install the DS cleint on windows and access the teradata on VM using ODBC.  
5862621 Jul 2016 @ 05:41 PDTsk8s3iDatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousI was wondering the same thing. How do we identify "continuity" of records in Teradata. It does not make sense. May be Hanu can explain his requirements and how he came across such a req...
5862521 Jul 2016 @ 05:28 PDTJohannes VinkDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GBAfaik is Data Services most of the time installed on Windows. The DS Designer tool runs only on Windows?
5862421 Jul 2016 @ 05:25 PDTjuanalfonsoDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GB Hello again, When I execute the first commands, at Run an Online Update, it seems to do nothing: TDExpress15.00.02_Sles11:/ # zypper ref -s All services have been refre...
5862321 Jul 2016 @ 04:21 PDTM.Saeed KhurramDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GBThe minimum patch level required for SAP DS is 2. Please be very carefull,as updating the patch may disturb the Teradata configuration on VM. You can follow the below link to update the patch leve...
5862221 Jul 2016 @ 04:15 PDTsachin.sebastianDatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousDon't understand how you identify 'only when col2 is continuous' : A physical file has order of records, but in Table does not have an implicit order of records. If this needs to ...
5862121 Jul 2016 @ 03:55 PDTvenkata_k01ToolsReplyZero records are fetching when using where statement in TPTCurrently also I am creating job variable file in perl script and then in the same script calling the tdload. Still issue exists. It would be very helpful if you could please elaborate/give me sam...
5862021 Jul 2016 @ 03:52 PDTM.Saeed KhurramAnalyticsReplyQUERY IN ASTER Before running a query, you must have a running instance of Aster. have you configured the Aster VM?
5861921 Jul 2016 @ 03:51 PDTjuanalfonsoDatabaseTopicProblems installing in TDExpress15.00.02_Sles11_40GB Hello everybody, I downloaded the Teradata Express 15.00.02 for VMware Player from the website and I'm trying to install SAP Data Services but I receive the following error: Fail...
5861821 Jul 2016 @ 03:18 PDTsk8s3iDatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousHi Carlos, I think his requirement is different. PERIOD will not be able solve this problem. He needs to partition the first two rows (WHERE Col2 = 100) and take the minimum and maximum date from ...

Pages