#DateForumTypeThreadPost
710 Dec 2014 @ 09:58 PSTDatabaseReplyComplex analytical query helpHi, "One problem in that. If the customer removed feature or cancel subscription in same month he added, then end_dt will give previous month end date. So count may go wrong for this scenar...
610 Dec 2014 @ 08:47 PSTDatabaseReplyComplex analytical query helpHi dieter, Some change in requirement. Table structure has changed. reporting columns are static. They are from Jan -15 to Dec - 17. CREATE TABLE subscriber_feature (SUB_ID INTEGER,...
509 Dec 2014 @ 12:13 PSTDatabaseReplyComplex analytical query helpHi Dieter, Thanks a lot, This is exactly what i was looking for and also learnt some new functions that i never came across in teradata.  Thanks a lot, Naga
408 Dec 2014 @ 04:25 PSTDatabaseReplyComplex analytical query helpI am using TD14
307 Dec 2014 @ 09:07 PSTDatabaseReplyComplex analytical query helpHi Dieter,   If feature added or removed both will be stored in feature_status. For both the action the event time is stored in  Feature_status_dttm. Using the feature_status and Featur...
207 Dec 2014 @ 04:11 PSTDatabaseTopicComplex analytical query helpDear Folks, I have a table with information like subscriber added/removed particular feature along with the date it added or removed. Also if he is active or canceled his subscription. CREATE T...
101 Mar 2012 @ 05:07 PSTGeneralTopicFSLDM I have experience with STAR SCHEMA. But I am new to FSLDM. Can any one explain what is B-Keys and B-MAP?