#DateForumTypeThreadPost
29608 Dec 2013 @ 09:22 PSTDatabaseReplyMerge statement showing 0 records mergedHi, What you can do is  take both the codes of DBA and your code and execute in bteq in unix/linux and see the results and compare if they match. I always trust Unix/linux more. Second, then...
29508 Dec 2013 @ 08:38 PSTDatabaseReplyMerge statement showing 0 records mergedHi, Few things that come to my mind maybe, just to narrow down the search: It was executed in a different environment, DBs etc, with data being available in one and not available in another. May...
29406 Dec 2013 @ 08:21 PSTDatabaseReplybackup or archive command Hi,   Backups and recovery are the strong points of Teradata. You can dump and restore data, with many check conditions  as per your requirements.   Unlike other v...
29306 Dec 2013 @ 07:54 PSTDatabaseReplyDefault date column not aligning in xcelHi, Did you use a trim function? Maybe it will help. Else in excel, you can write a formula or program for those dates where you see they are not proper. Cheers, Raja
29206 Dec 2013 @ 10:05 PSTDatabaseReplyScript to compare two databases (Tables and Views definitions)You are welcome.  Good luck, Raja
29106 Dec 2013 @ 09:49 PSTDatabaseReplyScript to compare two databases (Tables and Views definitions)Hi Khurram, This script is not tested but I think you will get the logic easily.  You can customize and expand more as per your requirements. Once you get the output, you can open in excel sh...
29005 Dec 2013 @ 08:24 PSTConnectivityReplyConnection From ORACLE using TPT TD 14.10Hi,  I think it is ODBC 14.00.00.02. Cheers, Raja
28905 Dec 2013 @ 01:56 PSTDatabaseReplyDistinct LogicHi, Can you please explain the logic how do you arrive at the output so that it will be easier put forth? How do you get ABC Y Y, because I can see ABC in four places. Cheers, Raja
28804 Dec 2013 @ 07:24 PSTData ModelingReplyDelete Partition Vs Drop Partition? Hi Khurram,   here:   say a row or column partitioning table use alter table1:   MODIFY drop range BETWEEN DATE 'your first date' AND DATE 'you...
28704 Dec 2013 @ 03:55 PSTData ModelingReplyDelete Partition Vs Drop Partition? Hi Khurram,   AFAIK: For both row and column partitioning, In case the Partitioned  table is created with no range clause, if you drop the range, then data will be move...
28603 Dec 2013 @ 11:06 PSTGeneralReplyTeradata seminars and events Hi Khurram,   Thanks for the links and info. I am looking more for face-to-face interaction ones where I can interact and meet. I appreciate your kindness.   Cheers,
28503 Dec 2013 @ 11:00 PSTTrainingReplyTeradata Developer trainingHi, You can get proper directions if you can tell the place where you are. You can get from this link , some info: http://forums.teradata.com/forum/training/teradata-online-training-online-terada...
28403 Dec 2013 @ 08:35 PSTDatabaseReplyneed a associated select query defined from view table in teradata?Hi, The easiest way is to export the results. It is available in "File..". You can run the query and it will ask you the directory where you want to place. Hope it helps. Cheers, Raja
28303 Dec 2013 @ 08:12 PSTCloud ComputingReplySAP AG,Siebel,Salesforce.com, Microsoft CRM,Amdocs -cloud serviceHi Khurram, Thanks for the links. I am looking more from CRM perspectives. Cheers, Raja
28203 Dec 2013 @ 07:47 PSTConnectivityReplyHow to establish Connection from Teradata to Hadoop and also for Hana Hi, You can also check on "Velocity Teradata". I have not used it. But just today someone from Teradata Netherlands suggest me. Maybe you can share your practical experience back to me :...
28103 Dec 2013 @ 07:38 PSTCloud ComputingReplySAP AG,Siebel,Salesforce.com, Microsoft CRM,Amdocs -cloud serviceThanks for the info. I am not aware of the PRIVATE CLOUD. Wish I can go through if someone has a document. I used to work in salesforce.com but want to get the opinions/suggestions or recommendati...
28003 Dec 2013 @ 07:35 PSTCloud ComputingReplySAP AG,Siebel,Salesforce.com, Microsoft CRM,Amdocs -cloud serviceI am not aware of the PRIVATE CLOUD. Wish I can go through if someone has a document. I used to work in salesforce.com but want to get the opinions/suggestions or recommendations on others for prop...
27903 Dec 2013 @ 07:29 PSTDatabaseReplyTeradata equivalent function to FROM_TZ in OracleHi Khurram, This is we normally do: First we run the help session to see the current setting; help session; You can set the default time zone at DBS control or User level when you create user...
27803 Dec 2013 @ 04:57 PSTCloud ComputingTopicSAP AG,Siebel,Salesforce.com, Microsoft CRM,Amdocs -cloud serviceHi , I know few of these -SAP AG,Siebel,Salesforce.com, Microsoft CRM,Amdocs have cloud service. May I know which of these work well with AEDW? Thanks and regards, Raja
27703 Dec 2013 @ 04:24 PSTDatabaseReplyget the list of System / Critical stored procedures in TeradataHi Gajanan, You can run the query : select * from dbc.tables where tablekind='P' . The field creatorname may help you identify the critical  one as per your organization policy. ...
27603 Dec 2013 @ 01:44 PSTDatabaseReplyNeed guidanceYou can log the merge errors into an error table. But I dont know from which version, this is available. But 14 I see this option. Cheers, Raja
27502 Dec 2013 @ 10:27 PSTDatabaseReplyDay Of Week or Week-Ending Function?Hi Nishant, You can just see (similar to)  in  'show select * from Sys_calendar.calendar' maybe, there you can get the logic of how you can get it. It is something using a mod fu...
27402 Dec 2013 @ 07:37 PSTUDAReplyDifference between key and index?As per your question: There is no such thing as unique primary key. Primary key is unique and not null. Yes, for those coming from other DB background, like oracle, the concept is  different...
27302 Dec 2013 @ 07:24 PSTDatabaseReplyDay Of Week or Week-Ending Function?I feel Sys_calendar.calendar is fine , until and unless we are driven to model another calendar, because of geography etc. Cheers, Raja
27202 Dec 2013 @ 07:41 PSTDatabaseReplyNeed guidanceIt is strange.  Could you run Explain merge into  and you can investigate. Also,since you run bteq, maybe you can run an os command  with say 'select before' before the merg...

Pages