0 - 17 of 17 tags for #database #teradata
Hi All,

I want to Write a query to duplicate each row based on the value in the repeat column? The input table data looks like as below

Products, Repeat
----------------
A,         3
B,         5
C,         2

Hi All ,
I have my table like this :
Id Name Country
1   Vaibhav India
2    Amit     UK
3     Pranav  US
 

Friends,
I'm working in Data Masking Company. Now I'm developing Teradata Scramble.
I've a situation here to scramble a table having more than 10 Lakhs to 10 Cores of records, but due to some performance issues I'm planing to split the records into many phases depends on total records and do the scramble for each and every phase.

I have the below code For T-PUMP WHICH IS not working .Please help me because t-pump has very less number of 
posts online

bteq<<eof1
SESSIONS 1;
LOGTABLE Etlt5.EMP_TPUMP_LOG;
.logon ttdbia/a0c9sx,blue@126;
BEGIN LOAD
PACK 5
RATE 10
ERROR TABLE EMPDB.TPUMPERROR;
 
.LAYOUT RECLAYOUT;
.FIELD id * varchar(10);

Any working professionals from USA Please contact me at venkylingutla@gmail.com for more details !!

i Have a question on Data validation.We use informatica Powercenter for Data Warehouse Deelopment/ETL.Having multiple source system sending Data to Datawarehouse,My Gola is to ensure source Data loads correctly to Target and I am performing Database validation.I looked in to some tool to validate the data.any advice on this is highly appreciated.

####################################
bteq <<EOF
.LOGON servername/username,********
/* sql code on next line(s) */
select  databasename from dbc.databases where databasename="P_EIW_S_LIS_01";
.export reset
.LOGOFF ;
EOF
###################################

Above is the BTEQ Script:

HI ,
Could someone hep in creating BTEQ Scripts in LINUX Operating system(NOT in UNIX). can we execute BTEQ script in LINUX or is their any issue while running in LINUX environment.
 
Help me creating .RUN file, if servername/username,password --> are credentials.
select * from dbc.tables-->is select statement

I have a table like below
 
Id startdate enddate rate
1 1/1/2015 2/1/2015 10
2 2/1/2015 3/1/2015 15
3 3/1/2015 4/1/2015 5
4 4/1/2015 5/1/2015 10
5 5/1/2015 6/1/2015 20
6 6/1/2015 7/1/2015 30

I am doing a FULL OUTER JOIN on 2 tables. Answerset I am getting is truncating leading '0's for one of the columns. Is there a special consideration/casting that we have to do when we do a FULL OUTER JOIN? The results are coming out fine when i am doing INNER JOIN(no 0 truncation)

 

I am trying to create a table in CTE named CATERGORYLIST in CTE. I used the below query
WITH CATERGORYLIST AS
(
                                 SELECT '1 Response' AS CATEGORY
                                 UNION ALL

Hi,
Can we check how much in % of index creation is completed..?
 
Say I have a table of 2TB in size; I just fired a command to create an USI and after some time if i wanted to know how much of it is created; can I check it...?
 

Senior Teradata DBA

Hi,
I am unable to get the intended result table.
I have the following table:
ORDERSERIALNO     USERID       PRODSKU         PRODUCTTABLE       NETREVENUE     ORDERPLACEDTIME          
123-345                   123            PHOTO01           CARDS                            44                  31OCT2010                  

Consider there is table with some ids. I want to search the ids that are not available in that table.
For eg: The table
id
--------
1991
1992
 
As of now, am writing this query
"Select * from table_name where id in (1991,1992,1993)"
From the result, I am manually finding out that 1993 is missing.

Hello Friends,
I do have consultant ( Teradata developer ) who is available for the project, His current location is in NC and he is open for anywhere inside EST on corp to corp basis, best way to contact me is by mail
email: chandru@ittblazers.com
Phone: 732-227-1772 X 141

Hi all
I have a table like BUSINESS_DATE_TBL which has 2 column of 1 date type and other varchar( this is one i use to create parameter).
my complete production load is dependent on this table as date in this table ensures for which day load will be triggered.