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

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?

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

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:

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.

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

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.

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'? 
Thanks
Peter

Hi,
Oracle DB offers a so-called multi-table insert statement which is very handy for ELT processing. It offers the possibility to insert multiple rows into one or more target tables from one source row. Here is a short example that should demonstrate what it does: 
-- source: source_table_1 - table with many columns

Can any one answer my Question...How can we connect (Different Oracle, Teradata) multiple database servers to join the tables from both DB's

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

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

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.
On 32-bit Windows platforms everything is peachy.

Hi -

Hi All
I am having problems while loading data from Oracle to TD14. In most cases the problem is with data type, like NUMBER(p,s), LONG RAW, NVARCHAR2 including Unicode, Multi byte and different Character Set etc.

Hi Guys
I am working on migration from Oracle to Teradata. I am facing few issues there. I would be glad if some one please clarify below questions.
 
1.

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.

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.

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?

I'm looking for some learning document for ODI. can some one foreward it to me.

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.
TeraData Version:  13.10
DataDirect Driver: 7.1 (64 bit trial for testing purpose)
Below is the Log.
 
 

Is there a way to record Production SQL queries and workloads so that they can be replayed in another environment?
Kind regards,
Steven

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.

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

Hello,

Hi! 

I'm rather new to Teradata so please sorry if the question is a simple one.

Hi guys I am a beginner and received an email from Oracle regarding JavaOne & Oracle Develop conference 2011 to be held in Hyderabad..

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.

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:
TPT_INFRA: TPT01036: Error: Task (TaskID: 6, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

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 !
Below is the screenshot of log generated while executing the same.

Teradata Parallel Transporter Version 13.00.00.02

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:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from LINK_TDDEV

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
**** 12:38:34 Fatal error received from ODBC driver:
STATE=S1C00, CODE=0,
MSG='[Oracle][ODBC]Driver not capable.'
=================================================================
= =
= ODBC Driver Information =

23/7/10 URGENT Immediate interview and start for the right candidate
Familiarity with Oracle Data Integrator (ODI) ELT tool set would be a definite plus.
This person will need to be capable of working with functional and technical project managers, and Cognos and data architects to determine the appropriate set-up, configuration, documentation and support processes required to extend an existing data warehousing environment based on Teradata.

Business Intelligence Architect
Position Type: Full-Time, Permanent
Company Name: HSGI Inc.
Location: Atlanta, GA
Primary Skills: BI, Architect, Data Modeling, Data Analysis, SQL, Data Warehouse, Data Mart, Dashboards

Urgent Job Opportunity!
Only Serious Candidates Need to Apply! We can set up interviews for you immediately!
Please reply with ALL of the following information:
• An updated copy of your resume in a Word (.doc) Document
• Current and expected compensation
• A brief introduction type paragraph outlining your skills and experience relative to the Job Description

Hi,
I am working on Teradata to Oracle migration project.

Select frm_crncycd,to_crncycd,exch_rate from exchange_rate
group by 1,2
qualify(rank(frm_dt)) =1

Can someone explain what is the behavior of above query.
So that i can rewrite the query in Oracle.

Hi All,
I'm trying to use TPT to load data directly from an Oracle table to Teradata. BUT.. I'm having a little problem with numeric data types.
In oracle, I have a lot of different NUMBER(10,0) and other columns.
Lets take one for example a column called DURATION. The actual data in this column fits in an INTEGER type easily. So in the SCHEMA in the TPT script file and in Teradata, i identified it as INTEGER.
Now when running the TPT script, i get this error:

Error: Row 1: data from source column too large for target column
Column: DURATION, Data: '3'