#DateForumTypeThreadPost
3123 Feb 2009 @ 08:31 PSTUDATopicDuplication RecordHi GuysI have created a query below and it giving me duplicates,what Im looking for is a unique customer record based on account_num or customer_number, i.e. need to report the latest account_num p...
3023 Feb 2009 @ 06:21 PSTUDAReplyEmail ValidationHiUnfortunately Im using Teradata SQL Assistant, we dont have C software in house.Thanks,Ince
2916 Feb 2009 @ 03:51 PSTUDATopicEmail ValidationHi GuysCan you please help me convert this function into Teradata function, This functions checks if the email is valid and return the correct email,See the function below:1.CREATE FUNCTION EMAILVA...
2802 Dec 2008 @ 02:23 PSTMarketing & CRMTopicCommunication PersonalizationHiI have read this chapter, Real-Time Communications, it says I should load data into IOS_CM_CHANN_CUST for real time event campaigns, the problem is that when I load data into this table, it cause...
2701 Dec 2008 @ 10:47 PSTMarketing & CRMTopicLoading Data to IOS tablesHiDoes anyone knows how to load data into IOS_CMS_CHANN_CUST table, I have tried to load data into this tables and it causing Batch to fail.Please advice.Thanks
2612 Nov 2008 @ 05:10 PSTMarketing & CRMTopicReal_Time CampaignHi GuysWe are now working on creating events on the TCRM application. I have been through the documentation but there are some things that don't make sense to me. This is what has been done so far:...
2505 Nov 2008 @ 06:18 PSTMarketing & CRMTopicTCRM RollUp FunctionsHi AllI have created a view that calculates the number of events performed by a client for 90 days, and further created the Legend to look at this field, i.e. number of credit event , and I have us...
2408 Oct 2008 @ 10:57 PDTUDATopicValid Cell PhoneHiCan you help with query below, I need to mark if the CellPhone is valid or not, this query does not show a cell number with less than 10 digit as invalid, please help me resolve this issues. SELE...
2323 Sep 2008 @ 09:10 PDTUDATopicQuery PerformanceHiCan you please help with the view below, I have problem using the QUALIFY statmement, it takes longer to return the result and when the view below joined with other views it becomes a nightmare.P...
2220 Aug 2008 @ 10:12 PDTMarketing & CRMTopicAdding NegativeTCRM does not take negative values, does any knows how to include negatives values on TCRM?E.g. Value Range from -100 to 100
2113 Aug 2008 @ 06:32 PDTDatabaseReplyLatest DateHi DalesI have tried using the option you suggested below, the query runs forever, this table ACCT_BAL_SUMMARY_DD has so many records,would be another suggestion to help be resolve this problem, an...
2013 Aug 2008 @ 06:09 PDTDatabaseReplyHighest PriorityThanks Dales, it works.
1912 Aug 2008 @ 05:57 PDTDatabaseReplyHighest PriorityHiI have table A which will be linked to table B containing my pririoty list,Table A is as follows:SELECT party_id ,O_Party_Id ,O_Party_Role_Cd ,Ext_Identification_Num ,Ext_Identification_Typ...
1812 Aug 2008 @ 02:27 PDTUDAReplyMaximum DateTable 2 Credit_Limit DDLCREATE MULTISET TABLE ince.CREDIT_LIMIT ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, FREESPACE = 0 PERCENT, CHECKSUM = DEFAULT ( Account_Numb...
1712 Aug 2008 @ 02:22 PDTUDAReplyMaximum DateCREATE MULTISET TABLE ince.balances ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, FREESPACE = 0 PERCENT, CHECKSUM = DEFAULT ( Account_Number DECIMAL(18,0) NOT NULL, ...
1611 Aug 2008 @ 08:07 PDTDatabaseTopicLatest DateHiI have created the query below to retrieve the maximum date in order to get the outstanding limit, but the query return more than one dates for the same account number,and I only one to see the l...
1511 Aug 2008 @ 08:05 PDTUDATopicMaximum DateHiI have created the query below to retrieve the maximum date in order to get the outstanding limit, but the query return more than one dates for the same account number,and I only one to see the l...
1411 Aug 2008 @ 07:12 PDTUDATopicData ConversionHiCan you please help me convert char(16) to decimal(18,0)e.g. select Cast(OAA_N as decimal (18,0) ) O_Account_Num from AccountError: It says bad character formatting.
1307 Aug 2008 @ 11:08 PDTDatabaseTopicHighest PriorityHiDoes any one knows how to create a query that will pick the highest priority of from the list below,if I have an ID_Number and Passport, the query must pick ID_Number since is the one with the hi...
1207 Aug 2008 @ 11:07 PDTUDATopicPrioritizingHiDoes any one knows how to create a query that will pick the highest priority of from the list below,if I have an ID_Number and Passport, the query must pick ID_Number since is the one with the hi...
1131 Jul 2008 @ 12:16 PDTDatabaseReplyOptimizing ViewThanks
1030 Jul 2008 @ 03:20 PDTDatabaseReplyCounting Record From Source FileI have tried to use the options below, but seems to be taking long to return something, although it works,you have to use the UNION ALL to retrieve all the required columns per table.SELECT TableN...
930 Jul 2008 @ 03:15 PDTDatabaseTopicOptimizing ViewHi GuysCan you please help me with a better approach to optimize the view below,the main driving table is CBF_DELIVERY, I have tried to create subqueries but the explain still looks bad,Can you ple...
817 Jul 2008 @ 06:35 PDTDatabaseTopicCounting Record From Source FileHiI have a query below from the DBC database identifying the databasename,tablename, and column.select DatabaseName,TableName,ColumnNameFrom dbc.columnswhere DatabaseName = 'testeiw'and ColumnName ...
726 Jun 2008 @ 09:53 PDTJobsReplyPermanent Teradata DBA OpportunityHiIs this position still available?Which country is this position on?Im interested.Regards,Ince

Pages