#DateForumTypeThreadPost
2916 Dec 2015 @ 10:02 PSTDatabaseTopicTricky Questions Hi Gurus, I came across thorugh a set of tricky questions while preparing for the cert. Request the experts to please help me out with the answers.   1)Which two statements describe t...
2819 Oct 2015 @ 05:09 PDTDatabaseReplyPerformance issue with Coalesce Okay. Got it . Thanks a lot :)  
2718 Oct 2015 @ 11:44 PDTDatabaseReplyPerformance issue with Coalesce Hi Dieter, Thank you for your reply. I had this notion and read at numerous places that Coalesce is troublesome to use, mostly in the join conditions. Thanks for clarifying that. Will check with...
2615 Oct 2015 @ 10:32 PDTDatabaseReplyPerformance issue with Coalesce Hi Dnoeth, Can you suggest anything on this? Regards, Amit
2513 Oct 2015 @ 01:16 PDTDatabaseTopicPerformance issue with Coalesce Hi All, I have one update statement as below: UPDATE ~DATABASE_NAME_BASE~.~TABLE_NAME~ SET EFFECTIVE_END_DATE = ?CURR_BUS_DATE?,  DW_UPD_LOAD_TIMESTAMP  = Current_timestamp(6) ...
2427 Sep 2015 @ 11:14 PDTToolsReplyAM/PM in TIMESTAMPOhh..yes..thanks Dnoeth :-). My data is faulty.   Thanks a Lot!!   Regards, Amit
2324 Sep 2015 @ 04:38 PDTToolsReplyAM/PM in TIMESTAMPHi All, I am trying to do the following: sel           cast ('20141121 083906 PM'         &n...
2222 Sep 2015 @ 11:57 PDTDatabaseReplyGet previous column vale till it reaches another not null valuejust use your year in the join column:   SEL M.EMPNO AS MAIN_EMP, M.EFF_DT AS MAIN_DT, L.TYPE_CD FROM MAIN M LEFT OUTER JOIN LKP L ON M.EMPNO=L.EMPNO AND EXTRACT(YEAR FROM M.EFF_DT)=EXTRAC...
2112 Aug 2015 @ 10:47 PDTDatabaseReplyImpact of unnecessary compress on all char and varchar columns.Sorry Carlos, I couldn't get a chance to reply to your post. Thanks for your input.  By "unnecessary compression" i meant they have not specified any values for compression...
2004 Aug 2015 @ 06:49 PDTDatabaseTopicImpact of unnecessary compress on all char and varchar columns.Hi All,  My client recently suggested to use compression on all CHAR and VARCHAR fields like the below: Customer_Name VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS, Customer_i...
1901 Jun 2015 @ 11:19 PDTDatabaseReplyRegular Expression On Teradata 14.0Excellent post ..lots of learning..thanks Satyaki de.
1826 May 2015 @ 11:23 PDTDatabaseReplyQuery PerformanceEvidently, there are many no confidence in the explain plan. Please check the stats.  
1721 May 2015 @ 02:23 PDTDatabaseReplyUsing Case statement instead of UnionHi Dnoeth, Could you please explain this helper table here? Thank You!
1620 May 2015 @ 11:13 PDTDatabaseTopicTPT LOAD OPERATOR TO lOAD RELATIONAL TABLES TO TERADATA TARGETHello All, Greetings!! I have one question regarding TPT. Can we use TPT LOAD OPERATOR TO lOAD ORACLE RELATIONAL TABLES TO TERADATA TARGET.   Since FLOAD only loads from flat files, can we...
1522 Apr 2015 @ 10:22 PDTDatabaseReplyTPT usage with informaticaHi All, We are using stream operator for the above scenario.However, i have few more questions i could not find the answers of. Appreciate any reply: 1)TPT does not create any control/loader log...
1422 Apr 2015 @ 10:20 PDTToolsReplyTPT Stream Loader - Create Macro Access error on target database (not working database).Hi All, I have one question here. Appreciate any reply: 1)TPT does not create any control/loader log for detailed error description when used with informatica. What are the options for troublesho...
1320 Apr 2015 @ 04:31 PDTDatabaseTopicdeadlock issue in simultaneous DML statements.Hi All, We have some files which are being loaded to teradata tables. The files are loaded via different pipelines in informatica and parallel insert, update and delete operations are taking place...
1226 Mar 2015 @ 02:32 PDTDatabaseTopicTPT usage with informaticaHi All, I have some questions on TPT usage with Informatica. We have some tables( with billion records) in oracle  and we have to load it to non empty Teradata table in a parallel m...
1105 Nov 2014 @ 04:13 PSTDatabaseTopicTable skew vs CPU skewIs it possible that a table has low table(data) skew but high cpu skew? I am doing a sel * from the table and i am getting high cpu skew(2.8) whereas the table skew is 7% and the data distribution ...
1005 Sep 2014 @ 12:47 PDTDatabaseReplyDate in varchar and DD-MMM-YY FORMATThanks Dieter, That worked!!   You make our life easier :).. --Amit
905 Sep 2014 @ 12:43 PDTDatabaseTopicDate in varchar and DD-MMM-YY FORMATI am stuck in this query. The below part "TRANSMITTED_DATE LIKE '17-JUL-14'" is hardcoded. I want to make it a generalized one. I want to do something like this WHERE CAST(TRA...
817 Aug 2014 @ 10:49 PDTDatabaseReplyInvalid TimestampHi All, I got hold of that issue in a different way, but can anyone please tell me what is the issue here?   Regards, Amit
712 Aug 2014 @ 11:20 PDTDatabaseTopicInvalid Timestamp Hi Gurus,   I have a requirement where i need to know what all sessions run between a particular timestamp which is input by user. The query below is throwing invalid timestamp erro...
603 Aug 2014 @ 11:24 PDTDatabaseReplyRank with Qualify not giving the exact results. Below is the query i ran:   Select Sub.NAME ,Sub.REVISION ,Sub.last_update_date FROM ( Select  --CDR_ODS_R_GE_OBJ_HST .FROM_ID as FROM_ID, CDR_ODS_R_GE_...
503 Aug 2014 @ 11:19 PDTDatabaseReplyRank with Qualify not giving the exact results.Hi Nagendra, Thanks a lot for your quick reply. I ran the query which you sent, but its giving only 24  records. Ideally it should give atleast 5M records as there are 5M distinct parts. Also...

Pages