All forum activity

#DateUserForumTypeThreadPost
5851718 Jul 2016 @ 02:25 PDTrou_oliToolsTopicTPT read fixed file and convert space to null valuehi, i search a TPT syntax but i'm not sure if it's possible. i have an input fixed file's. Two columns as a varchar(15) and a varchar(8) and the second column can contain 8 space...
5851618 Jul 2016 @ 02:10 PDTJohannes VinkDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tableI stand corrected ;-)
5851518 Jul 2016 @ 02:08 PDTJohannes VinkConnectivityReplyconnecting to Teradata from Oracle DB &SAP BWYes this is possible with a product from the Teradata SAP COE. TVAS/TELS the product was called. But you need to contact them.
5851418 Jul 2016 @ 12:33 PDTnambirDatabaseTopicWITH RECURSIVE issueHi ,   I want to find the all dependent jobs on one job. SO table2 had full dependncy data of what is dependant on what. Is there any way I can use WITH RECURSIVE and find the complete dept...
5851318 Jul 2016 @ 12:08 PDTCarlosALDatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousHi. And what stops you from looking it up in the documentation (SQL Data Manipulation Language, Chapter 1)? Cheers. Carlos
5851217 Jul 2016 @ 04:53 PDTdnoethDatabaseReplyAssigning a value of 1 only to the lowest value for an address type for each customerID in a tableThis should return the expected result: case when address_type = min(address_type) over (partition by customerID) then 'Y' else 'N' end  
5851117 Jul 2016 @ 04:48 PDTdnoethDatabaseReplyText Manipulation-Identify a 6 Character String and Replace with Ideal text Simply use a regular expression, this will replace exactly 6 digits: REGEXP_REPLACE (description, '[0-9]{6}','£')
5851017 Jul 2016 @ 04:42 PDTdnoethGeneralReplyConverting Time stamp in UTC including Day light SavingYou get a timestamp with daylight savings but without the time zone? How do you know the actual time for '2016-10-30 01:30:00'?   You might try SET TIME ZONE  'europe w...
5850917 Jul 2016 @ 02:23 PDTkudentovDatabaseTopicAssigning a value of 1 only to the lowest value for an address type for each customerID in a tableHi, I have a table with many customerIDs and each customerID can have many records each with a different address type. The address types are assigned values as follows: 1 = Home address, 2 = Postal...
5850816 Jul 2016 @ 03:07 PDTtapsips1DatabaseTopicText Manipulation-Identify a 6 Character String and Replace with Ideal text Hi   I have description column in a table that is pulling in a 6 character integer (like 123456) from somewhere. I would like to identify the 6 character string and replace it with the ...
5850716 Jul 2016 @ 01:54 PDTvenkata_k01DatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tableyes Khurram.Noticed the same while creating the table. Thank you.
5850616 Jul 2016 @ 01:52 PDTvenkata_k01DatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousHi Carlos,   I am not familiar with PERIOD & NORMALIZE clause, Could you please elaborate and give sample query.   Thanks, Hanu
5850516 Jul 2016 @ 01:49 PDTvenkata_k01ToolsReplyZero records are fetching when using where statement in TPTHi Steve, I ran the same select query using bteq and it fetched 126332 records as expected. SELECT * FROM UDWBASEVIEW1.MBR WHERE SRC_ROW_EFF_DT >='2016-07-10' AND SRC_ROW_EFF_D...
5850416 Jul 2016 @ 01:47 PDTCarlosALDatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousHi. You can use a PERIOD datatype from your begindate & enddate and use a NORMALIZE clause. Cheers. Carlos.
5850315 Jul 2016 @ 07:17 PDTRaj YConnectivityTopicconnecting to Teradata from Oracle DB &SAP BWHello Everyone,   i am doin a POC by  connecting to Teradata DB from Oracle DB and SAP BW to transfer the data from Oracle and SAPBW. Is it possible ? if yes, please guide me how to do ...
5850215 Jul 2016 @ 04:29 PDTteradatatesterDatabaseReplyMedian function - Fails on view when trying to cast as decimalIf I add myCol1 and myCol2 to the GROUP BY would that make the results wrong? SELECT  myDate ,CompanyName ,Median( cast( myCol1 as DECIMAL(18,3)) ) as MedianCol1 ,Median( cast( myCol2...
5850115 Jul 2016 @ 04:22 PDTteradatatesterDatabaseReplyMedian function - Fails on view when trying to cast as decimalLooks like the problem is the data. Sometimes myCol1='0.0000' and sometimes myCol2 ='0.0000'.
5850015 Jul 2016 @ 03:43 PDTFredThird Party SoftwareReply'enabled' columnSpecify the column name as a quoted identifier, i.e. "enabled"
5849915 Jul 2016 @ 03:38 PDTFredDatabaseReplyMedian function - Fails on view when trying to cast as decimalNot sure what you are asking. You say myCol1 / myCol2 are INT but a CAST from INT to DECIMAL would not require string translation.   If you are trying to exclude some rows from the MEDIAN ca...
5849815 Jul 2016 @ 03:36 PDTSNguyenWFTeradata StudioReplyStudio Express severe keyboard lagI have a new observation with this issue.  I notice that when I have a big block of commented code, when I type or use the arrow keys within it, there's no lag, but when I go to another se...
5849715 Jul 2016 @ 02:42 PDTM.Saeed KhurramDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tableHi, There is no need to write WITH PRIAMRY INDEX, WITH is required for NO PRIMAARY INDEX. Normall Syntax is: CREATE TABLE UDWETLWORK_D5.MBR_COV_TST_tmp AS ( SELECT * FROM UDWETLSANDBOX.ADJD_M...
5849615 Jul 2016 @ 01:09 PDTteradatatesterDatabaseReplyMedian function - Fails on view when trying to cast as decimalAnyone?
5849515 Jul 2016 @ 12:30 PDTfeinholzToolsReplyTPT Export vs Fast ExportFastExport will process the blocks in order. TPT Export can have multiple processes, each process controlling multiple data sessions, and thus you can get parallelism extracting the data from Tera...
5849415 Jul 2016 @ 12:27 PDTfeinholzToolsReplyZero records are fetching when using where statement in TPTThat is the console output. The log itself will have the output from the Export operator. However, before looking at the log, you should try the exact same SELECTG request with BTEQ just to make ...
5849315 Jul 2016 @ 11:55 PDTindra91ToolsReplyTPT Export vs Fast ExportThanks for the info Steve .But as you pointed out TPT offers parallelism on the client load server does that mean improvement in performance in my scenario?As far as I know FastExport also creates ...

Pages