#DateForumTypeThreadPost
62324 Feb 2014 @ 04:58 PSTDatabaseReplyDate as IntegerUsually this is done in the ETL phase .... which is responsible for fetching new data and populating Core/EDW tables.   About where to implement, you can implement it in an SP or in the SQL ...
62224 Feb 2014 @ 03:44 PSTDatabaseReplyDate as IntegerHTH!   DROP TABLE EDW_TAB; DROP TABLE STG_TAB; CREATE VOLATILE TABLE EDW_TAB ( ID INT, NAME VARCHAR(10), ADDRESS VARCHAR(50), START_DATE DATE, END_DATE DATE ) ON COMMIT PRESERVE...
62124 Feb 2014 @ 03:31 PSTDatabaseReplyDate as IntegerI will share some basic SQLs sometime today.
62024 Feb 2014 @ 03:31 PSTDatabaseReplyDate as IntegerAlso, in case data is there but address value has changed, you need to UPDATE the previous row and set:   END_DATE = CURRENT_DATE;   And INSERT new row [with updated Address] as befor...
61924 Feb 2014 @ 03:29 PSTDatabaseReplyDate as IntegerA simple way to cater for SCD Type 2 would be as follows:   Assume you have a table as below:   Table1 ID INT, NAME VARCHAR(10), ADDRESS VARCHAR(50)   And you wish to track ...
61824 Feb 2014 @ 02:50 PSTData ModelingReplyUnderstanding on Data modeling conceptsAlso note .... Logical DM is database independent, hence can be learned irrespective of which database is present underlying.   For Physical DM, yes you need to have a good understanding of ...
61724 Feb 2014 @ 02:43 PSTData ModelingReplyConverting Rows to ColumnsYou can have a look at following links:   http://forums.teradata.com/forum/database/sql-to-transpose-row-to-column-any-level-nth-level-of-data http://forums.teradata.com/forum/database/tran...
61624 Feb 2014 @ 02:33 PSTGeneralReplycheck session historyTo have a correct track of SQLs executed, you need to have DBQL enabbled. It can be enabled for a particular user or for all users system-wide.   You can also ask your DBA to enable it for y...
61524 Feb 2014 @ 02:29 PSTDatabaseReplyTable StatsCollecting stats is a step-by-step process, and there is no 100% correct way of doing it. There can be a scenario which works best for you today .... but may not work the same way after some time [...
61424 Feb 2014 @ 02:25 PSTDatabaseReplyRegular Expression On Teradata 14.0Great work in progress Satyaki .... you should really consider publishing an article on this. :)   Can you also add some performance stats on these?
61323 Feb 2014 @ 07:41 PSTGeneralReplyFYP ideasIts a fantastic idea. You can work around Call Detail Records - CDRs. Search for it on the web .... relating to that you can work on different aspects of reporting as well.   But first you n...
61223 Feb 2014 @ 07:35 PSTGeneralReplyFYP ideasSo briefly, first check if you can get some assistance from local Teradata office. In parallel, finalize the industry to work with. And also try to find some contacts in the industry and have a dis...
61123 Feb 2014 @ 07:33 PSTGeneralReplyFYP ideasFor the contact .... am online here usually, so you can ask anything you want here.
61023 Feb 2014 @ 07:27 PSTGeneralReplyFYP ideasFor the model .... you can get some documentation but getting an actual model would not be possible. Its a product from Teradata .... and you cant get it for free .... and am sure you wont be going...
60923 Feb 2014 @ 07:25 PSTGeneralReplyFYP ideasDo you have a local Teradata office? And if yes, can you find some reference there .... may be via your university?
60823 Feb 2014 @ 07:09 PSTGeneralReplyFYP ideasI would suggest you to get some sort of model from your teachers, and then you can change it your way.   Regarding industry selection, what interests you the most .... which industry do you ...
60722 Feb 2014 @ 10:28 PSTDatabaseReplyDate as IntegerIt would be better to store it as a date, but when you need to show it on a frontend, you can use CAST with FORMAT to specify the required format i.e. 'DDMMYYYY'.   HTH!  
60622 Feb 2014 @ 10:26 PSTDatabaseReplySQL helpYou can invoke FastExport script, or you can read data and generate a file in your application.   SQL doesnt generate file, its the application above that does it after getting the data form...
60522 Feb 2014 @ 10:22 PSTGeneralReplyerror: The format or data contains a bad characterCan you share the values of the column: a13.FiscalWeekID
60420 Feb 2014 @ 11:31 PSTTrainingReplyTERADATATopic moved to 'Training'.
60320 Feb 2014 @ 10:18 PSTGeneralReplyFYP ideas8-10 months is a good enough time.   You can work on a project comprising of some subject-area(s) of an industry .... and you can have some related reports done.   Have you given a th...
60220 Feb 2014 @ 10:15 PSTDatabaseReplyMultiple values using case statementAnd what output do you expect from following:   exec samplemac('0');  
60120 Feb 2014 @ 10:13 PSTDatabaseReplyDate as IntegerWhat are the other columns in your table Test?   You need to have a join in an update based on same [but uniquely identifying] columns.
60020 Feb 2014 @ 05:47 PSTDatabaseReplySequence GeneratorMost easiest way would be as follows:   CREATE TABLE tab1 ( Name VARCHAR(10) ); INSERT tab1 VALUES ('a'); INSERT tab1 VALUES ('b'); INSERT tab1 VALUES ('c'...
59920 Feb 2014 @ 05:41 PSTDatabaseReplyMultiple values using case statementBut how do you plan to relate 206 and 0? On what basis?

Pages