#DateForumTypeThreadPost
2713 Mar 2014 @ 08:05 PDTDatabaseTopicInsert not workingI Have a master OLTP table A and Target table B (Built based on the source table A). The source table will get new data everymonth and i need to update the target table B using Insert (New Data) an...
2612 Mar 2014 @ 03:04 PDTDatabaseReplyDate as IntegerI am trying to change both Business and segment as these are type 2 fields in the table. So this update statement needs to be added after the above code i have provided?
2511 Mar 2014 @ 05:17 PDTDatabaseReplyDate as IntegerI dont have access to the SP's and i am on TD12, so decided to write a series of Insert and update statements to tackle the type2 objects. Source Table A Target Table B, i want to update this...
2403 Mar 2014 @ 04:15 PSTDatabaseReplyDate as Integer Hello, can some one please help me on this.  
2326 Feb 2014 @ 08:55 PSTDatabaseReplyDate as IntegerThanks for the code Adeel, but i have realised that i dont have permissions to write the stored proc, so wondering what other alternatives do i have now? May be a macro or a series of insert updat...
2224 Feb 2014 @ 06:54 PSTDatabaseReplyDate as Integerhow to modify the above SQL for a SP?
2124 Feb 2014 @ 06:40 PSTDatabaseReplyDate as IntegerNo ETL tools are being used, manual SQL codes, so SP is my option then.
2024 Feb 2014 @ 04:50 PSTDatabaseReplyDate as IntegerGreat, Thanks a ton Adeel!! But can you please explain how/Where do i implement this in realtime? and where do i write this SQL. does it needs to be created as a view in SQL assistant or in any ot...
1923 Feb 2014 @ 01:19 PSTDatabaseReplyDate as IntegerThanks Adeel, Can i please ask you for one more favor, i have gone through many articles and forums but couldn't manage to figure out the best method to impelement SCD type 2 objects in a tabl...
1821 Feb 2014 @ 07:14 PSTDatabaseReplyDate as IntegerI am trying to achieve if the date is 28/11/2004 i need to and store as 28112004, but using the above sql kindly provided by Dieter  it is coming as 1041128. one more example, for 26...
1721 Feb 2014 @ 02:21 PSTDatabaseReplyDate as IntegerThere is already a calendar date column in the table, i am trying add the same date column  as Int, which will be used as unique id and easy to join as it will be integer.
1620 Feb 2014 @ 08:46 PSTDatabaseReplyTable StatsIt is working, but only one column at a time. Is there a way we can set stats on a whole table at a single shot. I have tried something like   COLLECT STATISTICS ON <DB.Table Name>, bu...
1520 Feb 2014 @ 06:58 PSTDatabaseTopicDate as IntegerHello, I am creating a new column in to an existing Date dimension table   Alter table DB.Test Add Date_Key INTEGER; And updating the field with data from  sys_calendar.calendar A...
1420 Feb 2014 @ 03:15 PSTDatabaseReplySequence GeneratorAdeel, i did understand the theory behind it but i am having difficulties getting my SQL to work as am new to this kind of stuff.. I have an existing table called DB.Test and my intension is to&nb...
1320 Feb 2014 @ 01:52 PSTDatabaseReplyTable StatsHello Adeel, Thanks for clarification in the previous posts. I have used the belwo SQL to get the stats COLLECT STATISTICS ON TEST COLUMN (TEST1); and 2 rows have been processed, how do i ...
1220 Feb 2014 @ 01:33 PSTDatabaseReplyOrder by DateHello Adeel, i am trying to create a view from your suggestion with SQL below CREATE VIEW VW_TEST (calendar_date, year_of_calendar, quarter_of_year) As Select calendar_date , year_of_calendar ...
1120 Feb 2014 @ 01:10 PSTDatabaseReplySequence GeneratorHello Adeel,   I already have the table, what i am after is adding a SKey using an Insert or an Update statement.    
1019 Feb 2014 @ 07:39 PSTDatabaseTopicTable StatsHello, I am pretty new to teradata. I am creating a simple data cube based on an existing transac table in TD12 and i have been told to collect the stats on a few tables i have created. So i am ...
919 Feb 2014 @ 06:37 PSTDatabaseTopicSequence GeneratorHello TD Guru's,   I am trying to create a seq generaor in to an existing table a below, but without any luck, can someone please help me with the SQL code INSERT INTO DB.TEST Seq_No I...
819 Feb 2014 @ 03:56 PSTDatabaseReplyBest way to generate the Sequential numbers : CSUM or IDENTITY columns?Hello Nishant,   Can i just check what did u end up with? Can you also please pass on the code as i am having difficulties getting it to work in TD12.   Cheers Reddy
719 Feb 2014 @ 03:33 PSTDatabaseTopicOrder by DateHello All, I have created a Date dimension table using sys_calendar.calendar table, but when i use a select statement on my Date_Dim table, the order of the rows is very eratic, is ...
618 Feb 2014 @ 08:25 PSTDatabaseReplySQL for Year and MonthAdeel you are a STAR mate, that has worked like a treat. Thanks a ton!!   As i have mentioned i am new to teradata or any other databases. can you please send a few reference docs or any oth...
518 Feb 2014 @ 08:10 PSTDatabaseReplySQL for Year and MonthApologies looking for something like "Jan'12"..."Feb'13"
418 Feb 2014 @ 08:08 PSTDatabaseReplySQL for Year and MonthMany Thanks Adeel, It has worked.   But i am interest in the last two parts of the year say '12 rather than 2012 for the year part.   Thanks
318 Feb 2014 @ 07:06 PSTDatabaseTopicSQL for Year and Month Hello All, I am fairly new to teradata and i am struck with some issue with the Sql on teradata 12   I have a Date dimension table with Year_of_Calender col...

Pages