connecting to Teradata from Oracle DB &SAP BW
,
15 Jul 2016
| 1 comment
Hello Everyone,
i am doin a POC by connecting to Teradata DB from Oracle DB and SAP BW to transfer the data from Oracle and SAPBW. Is it possible ? if yes, please guide me how to do that ?
i am using TD 15 version.
Thanks in advance,
Raj Y
What is the equivalent of "CONNECT_BY_ISCYCLE" in Teradata
,
27 Jun 2016
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?
Querying an Oracle database from a Teradata query
,
11 Jan 2016
| 3 comments
Dear all,
I would like ti create a DB Link from a Teradata database (v. 14.10.05.09) to an Oracle database (10g) but the Create DBLink query doesn't work. I have looked on the Internet about this, but I didn't find anything relevant about it? How should I proceed to create the link between the two environments?
Thank you in advance
Help to permute records of a table and update into the same table (from mathematics background)
,
16 Dec 2015
Hands-on with Teradata QueryGrid™ - Teradata-to-Oracle
,
06 Nov 2015
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.
Oracle Decimal to Teradata integer in TPT script
,
28 Sep 2015
| 4 comments
I am writing a PT script which loads from an oracle source to Teradata.
PROBLEM_COL in Oracle is defined as DECIMAL(10,0). In Teradata PROBLEM_COL is defined as Integer.
The load fails, and all rows are inserted into the error table.
Reviewing the logs I believe I see the problem:
avg sale of quarter with previous quarter sale
,
01 Sep 2015
| 9 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.
Teradata preferences for new connection profile type missing
,
19 Aug 2015
| 12 comments
Hi,
I'd like to connect to a Oracle database using Teradata Studio 15.0.01 but I'm missing the tab "New Profile Connection Types" in "Window" - "Preferences" - "Teradata Datatools Preferences".
Any ideas?
Regards
Daniel
OBIEE 11g Integration with Fuzzy Logix DB Lytix On Teradata
,
27 Jul 2015
Oracle BI Enterprise Edition (OBIEE) 11g Configuration and Integration with Fuzzy Logix DB Lytix™ On Teradata
This 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.
Oracle to Teradata 101
,
10 Jun 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.