#DateForumTypeThreadPost
628 Jan 2015 @ 02:51 PSTDatabaseTopicPartition Row number usage SELECT a.col1 ,CASE WHEN b.cust_id IS NULL THEN 0 ELSE 1 END AS is_true FROM DB1.table1 AS a LEFT JOIN DB2.table2 AS b ON ( a.col3 = b.cust_id AND a.start_date BETWEEN '2015-01-01&...
528 Jan 2015 @ 02:49 PSTGeneralReplyROW_NUMBER() OVER (PARTITION BY col1,col2.... order by col1) SELECT a.col1 ,CASE WHEN b.cust_id IS NULL THEN 0 ELSE 1 END AS is_true FROM DB1.table1 AS a LEFT JOIN DB2.table2 AS b ON ( a.col3 = b.cust_id AND a.start_date BETWEEN '2015-01-01&...
408 Jan 2015 @ 02:55 PSTDatabaseReplyAdding a date filterHi, I have data from 11-01-2013 to 12-31-2014. the data gets refreshed every week. So Please help me to filter the data only for latest 12 months. I have date column 'WeekEndingDate' which...
324 Jun 2014 @ 03:31 PDTConnectivityTopicExecuting Teradata sql script in Shell fileHi, I am new to Teradata. Please help me to know how to execute the simple Teradata script from LINUX shell script. I created  a shell file Sample.sh and the code inside the shell file is b...
224 Jun 2014 @ 12:35 PDTConnectivityReplyHow to connect to TeraData in SHell ScriptHi, I am newdie to shell scripting, Please suggest for my issue. When I try this code in shell script, I am getting the error ".LOGON: command not found". I executed the simple sql scr...
114 May 2014 @ 12:06 PDTDatabaseReplyRecommend books about TeradataHi , I am new to Teradata. I would like to know how Teradata db is a datawarehouse? As per my understanding, for example: I extract operational data from Oracle DB and transforms the data &n...