![]() |
Hello Everyone,
15 Jul 2016
| 1 comment
,
|
![]() |
Hi
I must make a porting of a query in Oracle that it contains the CONNECT_BY.
I know that in Teradata it is replaced with the WITH RECOURSIVE, but there is also the function CONNECT_BY_ISCYCLE.
How can I replace it in TERADATA?
27 Jun 2016
,
|
![]() |
Dear all,
11 Jan 2016
| 3 comments
,
|
![]() |
|
![]() |
Teradata QueryGrid enables high performance multi-system analytics across various data platforms. QueryGrid: Teradata-to-Oracle provides powerful SQL based functionality allowing you to join datasets across Teradata and Oracle systems.
06 Nov 2015
,
|
![]() |
I am writing a PT script which loads from an oracle source to Teradata.
28 Sep 2015
| 4 comments
,
|
![]() |
I have a table t in which there are various attribute like product,year,qtr,month,sale. I have to calculate the avg_qtr sale and show previous avg_qtr sale. I have used windowing function to show previous avg_qtr sale. I have read about lag but here it is not possible to use as it is not fixed after how many rows it will be repeated.
01 Sep 2015
| 9 comments
,
|
![]() |
Hi,
19 Aug 2015
| 12 comments
,
|
![]() |
Oracle BI Enterprise Edition (OBIEE) 11g Configuration and Integration with Fuzzy Logix DB Lytix™ On TeradataThis article describes how to integrate Oracle BI Enterprise Edition (OBIEE) 11g with Fuzzy Logix DB Lytix™ 1.x on Teradata to enable transparent OBIEE end user access to the advanced analytic functions from Fuzzy Logix. Fuzzy Logix’s DB Lytix™ 1.x includes libraries of in-database models that run deep inside Teradata Systems. Use of these models allows execution of analytics within the database, leveraging the performance, parallelism and scalability of Teradata system while dramatically improving the performance of analytic results and simplifying the integration of analytics into existing reporting and analytic applications.
27 Jul 2015
,
|
![]() |
If you've worked with Oracle for years and now find yourself the DBA for a Teradata Data Warehouse, you'll want to get productive as soon as possible.
10 Jun 2015
,
|
![]() |
I am using Teradata Studio as a single environment to run against multiple types of databases. One of these is an Oracle database. I notice when running that type of query, the results show up in a different window titled "SQL Results". There don't seem to be any preferences for this window.
08 Apr 2015
| 1 comment
,
|
![]() |
When connecting TD14 with Oracle 11 or 12, I've read that USL 15 allows connecting them with a portal server in between. When creating the foreign server, hosttype would normally be 'portal' as that's what's in the middle between TD and Oracle. In what scenario would we use hosttype 'oracle'?
14 Mar 2015
,
|
![]() |
Hi,
05 Feb 2015
| 4 comments
,
|
![]() |
Can any one answer my Question...How can we connect (Different Oracle, Teradata) multiple database servers to join the tables from both DB's
08 Sep 2014
| 1 comment
,
|
![]() |
Hi Team
While performing calculations I am facing some precision issues between output from Oracle and Teradata.Please Help.
-- Oracle SELECT ROUND((((3.82/23.88)*23.88)/767),2) FROM dual --0.000
-- Teradata
01 Sep 2014
,
|
![]() |
Hi Team
While performing calculations I am facing some precision issues between output from Oracle and Teradata.Please Help.
-- Oracle SELECT ROUND((((3.82/23.88)*23.88)/767),2) FROM dual --0.000
-- Teradata
01 Sep 2014
| 2 comments
,
|
![]() |
Since it appears SQL Assistant is still available only in 32-bit version (TD 14/15 clients), it attempts to connect to Oracle's 32-bit ODBC.
13 Aug 2014
| 4 comments
,
|
![]() |
Hi -
04 Jun 2014
| 3 comments
,
|
![]() |
Your company is new to Teradata and wants to move Oracle managed user data into the new data warehouse. As a DBA, your assignment is to move this data into the Teradata system.
06 Jan 2014
,
|
![]() |
Hi All
21 Nov 2013
| 4 comments
,
|
![]() |
Hi Guys
16 Oct 2013
| 1 comment
,
|
![]() |
This webcast describes how you can leverage Essbase and Teradata Database technologies to improve your analytical application environment.
09 Oct 2013
,
|
![]() |
Hi all First post. Apologies in advance if this question has been asked to death before and/ or if I'm posting this to the wrong section.
01 Oct 2013
| 11 comments
,
|
![]() |
Hi all First post. Apologies in advance if this question has been asked to death before and/ or if I'm posting this to the wrong section.
01 Oct 2013
| 1 comment
,
|
![]() |
Hello everyone - I have the Oracle 11g client and components installed but the Oracle OleDB Provider will not show up in the list of options in the OleLoad tool. I have manually registered the oraoledbb11.dll file and complete the installation multiple times. Has anyone ever used the Oracle OleDB provider before?
17 Sep 2013
| 1 comment
,
|
![]() |
I'm looking for some learning document for ODI. can some one foreward it to me.
03 Jun 2013
| 1 comment
,
|
![]() |
I am getting below error while trying to connect to Oracle DB using DataDirect 7.1 ODBC drivers from TPT script. I am able to test the connection using the example executable program in DataDirect and it works fine.
10 Dec 2012
| 9 comments
,
|
![]() |
Is there a way to record Production SQL queries and workloads so that they can be replayed in another environment?
09 Nov 2012
| 4 comments
,
|
![]() |
This course covers the various things you need to know when converting applications that processed your Oracle database.
23 Oct 2012
,
|
![]() |
I've got Fastload opening a named pipe, and I'm redirecting the output from a SQL*Plus script to the pipe in Windows. I assumed this would be far faster than allowing SQL*Plus to spool the result to a file locally, and fastload to import the flat file. Turns out it's not.
14 Sep 2012
| 1 comment
,
|
![]() |
I have to do the following transformation Round(sum(column),2)
The datatype of column is float.. Round() function is available in oracle. --How to implement this requirement in Teradata.Should I use CAST()? I have another query: Suppose the column contains values like 20.123456
31 Aug 2012
| 1 comment
,
|
![]() |
|
![]() |
Hi! I'm rather new to Teradata so please sorry if the question is a simple one.
21 Dec 2011
,
|
![]() |
Perhaps the easiest way to transition from a flat logic mindset to a set logic mindset is to convert some Flat SQL to Set SQL, then stare at both of them until the logical equivalence of the two approaches becomes clear.
26 Apr 2011
| 2 comments
,
|
![]() |
Hi guys I am a beginner and received an email from Oracle regarding JavaOne & Oracle Develop conference 2011 to be held in Hyderabad..
06 Apr 2011
,
|
![]() |
I am loading a column from an Oracle table defined as DECIMAL(30,3). I am using the ODBC interface to exract the data. I have the columns defined as DECIMAL(30,3) in the Teradata table. The completes without errors but the values are all divided by 1000. For example, Oracle value = 1000, Teradata = 1. Maybe it's an ODBC setting.
18 Feb 2011
| 13 comments
,
|
![]() |
hi everyone, I'm loading a Teradata table from an Oracle table using TPT utility. For this running a TPT and facing a weird error which says: I tried to investigate but couldn't find anything. If someone has faced such kind of error before, or knows about plz plz plz help. Its very urgent ! Teradata Parallel Transporter Version 13.00.00.02
14 Jan 2011
| 1 comment
,
|
![]() |
Hello everyone, I'm trying to get a Teradata ODBC driver to work on an Oracle/AIX platform instead of windows. I've gotten the Tnsping working, however when I go to use the link I recieve the following error message: ERROR at line 1:
21 Dec 2010
| 4 comments
,
|
![]() |
I am trying to use TPT to move a table from Oracle 10g to Teradata 12 using the ODBC operator with Oracle ODBC driver 10.2.0.3. When I execute the script with tbuild, I get EMAIL_SRC_CD_LK_ODBC: connecting sessions
17 Sep 2010
| 6 comments
,
|
![]() |
This article will introduce the new features and performance enhancements that have been added to Teradata SQL Assistant 13.10 Edition 2. The focus of this release is on usability and performance. Please see What’s new in Teradata SQL Assistant 13.10 for details of the new features that were added to the original 13.10 release.
28 Jul 2010
| 38 comments
,
|
![]() |
23/7/10 URGENT Immediate interview and start for the right candidate
23 Jul 2010
,
|
![]() |
Business Intelligence Architect Urgent Job Opportunity!
29 Apr 2010
,
|
![]() |
Hi, Select frm_crncycd,to_crncycd,exch_rate from exchange_rate Can someone explain what is the behavior of above query.
24 Mar 2010
| 4 comments
,
|
![]() |
This article will introduce the new features and performance enhancements that have been added to Teradata SQL Assistant 13.10. The focus of this release is on usability and performance.
29 Jan 2010
| 23 comments
,
|
![]() |
Hi All, Error: Row 1: data from source column too large for target column
19 Jan 2010
| 1 comment
,
|
![]() |
From time to time I’m asked how one might go about writing an UDF or an INMod or some other procedural extension to the database. The question isn’t a “where do I learn C or C++” question; rather it is a how do I go about debugging and testing my extension without the overheads and constraints of running within the database (or utility).
01 Aug 2009
| 20 comments
,
|
![]() |
There is now a new command line interface to Teradata Parallel Transporter! TPT users have been asking for this for a while now, and we have delivered. We will explore here a brief summary of what it is and how to use it.
29 Apr 2009
| 107 comments
,
|
![]() |
A collection of UDFs that emulate the most-commonly used Oracle built-in SQL functions.
22 Jun 2008
| 15 comments
,
|