All Forums

For topics on Teradata enterprise-level features and products. From single system features such as fallback, journaling, backup and Disaster Recovery Strategies to Dual Active systems. Topics will include Multi-System monitoring and control using TMSM; Data Synchronization, covering topics such as Replication Services (TRS), Data Mover (TDM), and dual loading as well as Multi-System workload management with Teradata Query Director (TQD) and TASM. Discussions about how to provide higher protection and consistent response times for your application encouraged. You must login to create a new forum topic.

Regarding Data Extraction....... Topic by lokhande.dinesh29 07 Jun 2007 Hi All,

i want to know how can i extract data from teradata into CSV files. i want know any of such tool available in market?

Thanks & Regards,
Dinesh
23753 views
5 replies, 8 hours ago
Very fast (and OpenSource) tool for extracting data from any DB is CloverETL (http://www.cloveretl.com/ ). It also has several bulk loaders for Orac...
dadik
Trying to Identify Logons that are not assigned to a the person whom it belongs to. Topic by Bohica 3 weeks ago Trying to Identify Logons that are not assigned to a the person whom it belongs to. I want to generate a report to accomplish this. Any help would be great.
409 views
4 replies, 2 weeks ago
Another thing to consider looking at is the ClientID column in the DBQLOGTBL table. This typically will have the network ID for the user that is l...
Woody
Slowly Changing Dimensions Topic by hsyed44 3 weeks ago Hi,

I get the basics of SCD's. Type 1 and type 2. I m just having trouble with how to implement the SQL. Could anyone please provide a SQL example as to how Type 1 and 2 SCD's would be implemented?

THanks,
362 views
1 reply, 2 weeks ago
Well from a theoretical standpoint, this is one approach: 1) Load your 'new' data into a staging table 2) Use a SQL Minus operator to detect ch...
walter.perz
joining table A to table B only once where condition satisfied Topic by barcoo 4 weeks ago Hello,

Please help where possible. I have been asked to determine if this work can be done in teradata, otherwise the work goes to another team here at work. None of us here at work know of a way but we are not experts. :)

Please read my example below along with my desci...
822 views
10 replies, 3 weeks ago
Hi Dieter. To answer your question - per CLIENTID there would be a max of about 10,000(very rare though) but the average would be 20. Total unique...
Surajit Choudhury
Timezone conversion Topic by veerabomma99 3 weeks ago Hi,



Can you please help me in converting the TIMESTAMP from GMT to PST.
182 views
0 replies
Packed decimal format issue. Topic by pratap_kudupudi 4 weeks ago Hi All,
I have an input file, where in the DECIMAL(7,2) is being sent in a Comp - 3 format.
Along with the actual values, it has few null values also being sent across.
I have tried to view the contents of the file using the cobol copy book and the null value looks something...
291 views
2 replies, 4 weeks ago
Hi, i tried it as suggested, but the job has failed with the following error. ** Invalid attempt to evaluate numbers against characters. Regards,...
sgbmyr
Teradata Forums migration imminent Topic by Host 4 weeks ago Dear users,



Per recent communication, we are pleased to announce the consolidation/merger of the Teradata Discussion Forums and the Teradata Developer Exchange Forums. The integration of the forums will create a single location - http://forums.teradata.com - for you to ...
162 views
0 replies
Teradata Forums migration imminent Topic by Host 4 weeks ago Dear users,



Per recent communication, we are pleased to announce the consolidation/merger of the Teradata Discussion Forums and the Teradata Developer Exchange Forums. The integration of the forums will create a single location - http://forums.teradata.com - for you to ...
201 views
0 replies
ARRAY Structure in Teradata Stored Procedure Topic by hba 18 Nov 2008 HI,

I am looking for details about object or datatype in Teradata stored procedure which will be work like ARRAY Structure. Is there any object available in TD which supports ARRAY kind structure?

Thanks in Advance.

Regards,
Harshad
13341 views
4 replies, 4 weeks ago
Thank you for responding to the question on Arrays. Can someone verify the approach I have taken to implement the array in Teradata based on the s...
sree1606
Using Teradata host for both database and ETL? Topic by Dante 4 weeks ago When working with Teradata I have always used one host (mainframe or midrange) to control ETL and the teradata database was isolated on its own hardware where nothing else was running. Has anyone worked with ETL processes that actually run on the Teradata host itself? Is there a good white pape...
247 views
0 replies
Needing Master Data Management advice Topic by hrmikwen 5 weeks ago Hello,

Thanks again for all of your support on the forum.
Already interested in different open source offers for data quality, we would be interested in a similar field.

We are thinking about Master Data Management software to complete our existing software. Woul...
327 views
1 reply, 4 weeks ago
You can look at different offers for Master Data Management. If you would like to use both data quality and Master Data Management software, I woul...
sukhi
Print command in stored procedures Topic by Radhika.Jakkula 5 weeks ago Hi,

In the below proc, I want to see the values in the variables SQL_STRING1 and SQL_STRING2 before the Call statement. What is the command to display the output. I tried "Print" but doesnt work. I am using v12 of Teradata SQL Assistant.

CREATE PROCEDURE aud_sales_split(...
217 views
0 replies
Stored Procedure Syntax - Variable Colon usage in Insert statements Topic by StephenHilton 5 weeks ago I apologize if this is a simple answer, but I was surprised today to find that the colon preceding a variable use in an INSERT statement was optional...

Consider this example:


CREATE TABLE Test_Variable_Syntax_Landing (
InsertType CHAR(10)
, caldt ...
319 views
0 replies
Improper column reference in the search condition of a joined table. PLZ HELP Topic by hsyed44 5 weeks ago Select

A.Column1
,B.Column1
Case When C.column1 is null
and C.column2 is null

then 'y'
else 'n'
end flag

from STG.table1 as A
,STG.table2 as B

left outer join
TGT.table1 as C
on A.column1 = C.colum...
487 views
4 replies, 5 weeks ago
Hey Ravi, Thanks for your help but i think i got what i was trying to accomplish. Your input would be helpful. This is what i was trying to do, ...
bhaney
'Pre-Built' dimension Topic by marcmc 6 weeks ago I am trying to understand the concept of a pre-built dimension.

The following DDL exemplifies my problem:

-- Step 1 - Create the staging table.
CREATE SET TABLE marc_centlook ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
311 views
0 replies
Install TTU on linux Topic by pwaltera 6 weeks ago Hi ...

I'd like to install the Teradata Tools and Utilities v13 (specifically TPT and BTEQ) on a linux client machine that is different than my database machine. How do I go about this?

Thanks.

Walter
286 views
0 replies
Teradata and Mainframe Topic by bonchibuji 28 Jan 2008 Hi

I will starting to work with teradata in a mainframe environment soon. Can anyone share some material and tips about it?

thx.
14423 views
3 replies, 6 weeks ago
Hi, We're running Teradata Utilities Foudation 8.2.2 on an IBM z/OS 1.9 system. We're planning to upgrade our z/OS to 1.11 and we'd like to know...
Giri_tdm
Need help loading data Topic by monty4u1 12 weeks ago Hi Experts,
I am new to Tera data development...
I am trying to insert multiple files that are in csv format into one tera data table...
The code mentioned below works file for one file at a time but I have 3 years of data in csv format for each individual day..
I have to ...
959 views
4 replies, 7 weeks ago
Merge all the files of different dates into one file, say all_files.csv Then use this file all_files.csv as the input file. Previous input file...
boj
Data quality question Topic by hrmikwen 7 weeks ago Hello,

Thanks for helping us on our last question.
We have looked at different open source offers for data integration. And we are now looking for data quality software able to complete the data integration software.

Are there any packages able to suit our needs?...
360 views
1 reply, 7 weeks ago
You can look at a lot of software for data quality. If you would like to use both data integration and data quality software, I would recommend you...
sukhi
Conditional where clauses Topic by Radhika.Jakkula 7 weeks ago Hi,

I want to implement an IF-ELSE logic in my where clause, some thing like below. I want the conditions in the IF-ELSE clause to be executed in sequence. I tried case statement also, but it doesnt work. Is there any way to implement such logic in Teradata? I am new to Teradata, hen...
351 views
1 reply, 7 weeks ago
Try this below (but check it gives you the result you expect): FROM F_SR_DMD_SALES_T DMD LEFT OUTER JOIN LKP_AMGEN_PRD_TO...
pranav-150
Split delimited column into separate rows Topic by paulcy 7 weeks ago Hello,
I have a record that has a column that contains delimited data, how can I split the delimited data into separate rows?

Current look
1 | A, B, C
2 | A, C

What I want:
1 | A
1 | B
1 | C
2 | A
2 | C

Thanks,...
306 views
0 replies
BULK INSERT in Teradata Topic by aolympio 22 Apr 2009 Hi guys!

Is there a command that performs a similar function as BULK INSERT(SQL statement) in Teradata?

Thanks for help,
Anderson
3688 views
3 replies, 7 weeks ago
If you want to do Bulk Insert to Teradata from VB.Net, C# or some other CLR language, I've created a Managed C++ wrapper for the Teradata Parallel ...
provost
TeraData vs Oracle Topic by nicky 30 Jun 2007 hi

Recently one of our client wants to make a selection between teradata and oracle 10g. I our evaluation tells me that oracle 10g is far better than Teradata. But it may be because there are so many persons working on oracle so will anybody here guide me
92568 views
22 replies, 8 weeks ago
BYNET is one of the reason differentiate teradata from other datawarehouses.
prachi
TPC_H benchmarks Topic by Rambazo 8 weeks ago Hello,

I get block in editing the makefile and I need to do so to succeed to access a data base: TPC H benchmarks.
I get blocked, I can not build the project.

Can you explain to me what is a makefile?
How to edit the makefile?
How to make it? in Vi...
301 views
0 replies
BI software forums Topic by hrmikwen 9 weeks ago Hello,

We will be settling for open source data integration software.
We would need to have a thorough documentation and a forum able to help us on problems if we have any with our solution.

Forums are always good to get solutions to problems. But need to be act...
352 views
1 reply, 8 weeks ago
Hi, I think you are right about having a thorough documentation for your open source software. There are a few solutions that have an active comm...
sukhi
You must login to create a new forum topic.