Hi all, 
 
Does anybody know how to set equal leads distributed in TRM 6.3?
For example, i've 5 campaigns running concurrently and im sending to the same salesperson/banker. how to configure in TRM so that the salesperson can get equally 5 leads for each campaigns?
hope you guys can help me on this :)

Hi all,
As a company we are using Teradata SQL Assistant 13.10 for query execution, we are new for Teradata and our editor has no intellisense feature. My question;
Is there any plug in to Teradata SQL assistant to activate intellisense feature or can you suggest me some other  teradata sql editor which will provide intellisense and better performans?
Thanks in advance.

I am trying to put into a table the output from a previous query (saved as a volatile table).  I am creating a new table PROC_STATS to hold the output and then using INSERT INTO followed by a SELECT query to get the data inot PROC_STATS.  When I run the code in SQL Assistant, I get a message that 1 row was returned, which is the correct value.  However, when I run SELECT * FROM PROC_STATS, no r

MK INFOTECH@KPHB
TERADATA ONLINE/CLASS ROOM TRAINING @KPHB BY REALTIME EXPERTS
 
 
304,Padmaja’s Raja Enclave, Opp.RS Bros,
Near KS Bakers, KPHB, HYDERABAD, AP,INDIA
 
ph:09247758121,040-65767999
 

I'm trying to load a flat file using Teradata Fastload.

The data file has been created using python script and the delimiter is Ctrl+A which I believe is equivalent to '\x01'. Here's the syntax I used 

SET RECORD VARTEXT '\x01'; 

The same file works with a pipe '|' or comma ','  delimiter. Can you please suggest.

Hello!  I am using Teradata release 13.00.01.03. I am having a terrible time with some syntax. I was hoping someone could help?
 

I'm trying to install Teradata 13.0 Express edition using VMware virtual OS (Win7 32bit). I click on the first installation step which is to install the bynet(x86) driver. But get the error: "Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor."

Hello Every one,
I have come across a problem in td_Stored Proc volatile tables,
Is  it volatile table  not allowed order by clause?
If it is, when i run the entire stored procedure and need to sort the results and here what is the soultions not alllowing of order by clause
 
~gopal

Explain SELECT
LDA_RDM_JPMCC_NM_ADDR_MTH_V.CUSTOMER_OBJECT_ID,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.ACCOUNT_NUMBER,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.WORK_PHONE_NUMBER,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.SRC_SYS_CD,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.CRE_RUN_ID,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.ETL_SRC_FILE_NB,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.ETL_ROW_NB,

I am running queries through a JDBC driver. I am able to execute select * from DBC.AccessRights with no issue. However, when I execute "SELECT COUNT(*) FROM DBC.AccessRights" I get the following error. Any help is appreciated. I can run both queries from bteq on the server.
 

Hi All,
 
i am just  trying to insert the million records if values into table but having the issues with this
i had the data in this formate 'PYE:879'-"sd4696' and i am not able to insert the records
Insert into Tab1 (Col1,COl2) Values ('Data','PYE:879'-"sd4696');
Can you please help on this issue
 
Thanks
 

Hi All,

Please help me suggesting a query to find

Hi All,
Please help me suggesting a query to find
                                                                 1.the scale of the column in teradata

Hi All,

Please help me suggesting a query to find

Hi, I have one scenario and I am looking for your help.
we have large DW with almost 10 different soruces with 400 tables. So, I want to know what are all sources are populating each table. 
in all these tables SRC_CD is Mandatory.
sel DISTINCT '?ACCT' as "TABLE_NM",
 

Let a name be 'Sayak chandra venkateshwar'
I want the output as
first name: Sayak
second name: chandra
surname : venkateshwar

Does anyone here use TRS?

If so is it reliable?

How much Data do you replicate? All or just a few tables?

How many TB or GB do you replicate per day?

HI,
 I have a very big fact table named F_BASE_SALES_TRANS_LINE and the size as aprrox 1 TB. This table contains detailed dat at
calendar_date, ITem_id, Store_num, TRANS_line_id... You can say the smallest granularity of each transaction at Retail store.
  Table structure is below..

Hi Teradata Masters,

I'm trying to provide data to be consumed by a Load Operator in my TPT script throught a named pipe.
My DATACONNECTOR Producer: (all runs local on Windows)

    DEFINE OPERATOR PIPE_READER()
    DESCRIPTION 'Define opcoes de leitura de arquivos'
    TYPE DATACONNECTOR PRODUCER
    SCHEMA T701S020_SCHEMA
    ATTRIBUTES
    (

Can anyone help me with the query to convert a decimal eg (19890523) to date format (1989-05-23)....

Folks,

we want a single query for checking

1. if the column is null or not

2. if it is not null then we should check that it doesnt contain  , - '' 

3. if the above 2 cases are passed , we want to check if it is a valid decimal(15) or not

thanks

I have a query and want to return the date as the field name. What do I need to do to turn the date value as a field name?

select Suppress_Cd, supp_desc,

count(distinct STHD_KY)  as CAST((CAST(DATE AS FORMAT 'MMMDD')) AS CHAR(5)) from testble

thanks

I have a source and a target. I want to make a post session failure command based on the record count of my source and target tables.

Thanks

I have this table:

Book

Task

Assignee

723983

A5Q

Maria

723983

A5Q

Ken

723983

A5Q

Phil

723983

WC13

Brian

724025

FRMDS

Jacob