|46428||28 Nov 2014 @ 02:24 PSTfirstname.lastname@example.org||Database||Topic||Help with SQL: redistributing data||Hi,
I am working on a query to combine multiple rows with overlapping dates for the same information. I use partition by and reset when to achieve this. However, even though the table has primary... |
|46427||28 Nov 2014 @ 10:09 PST||BlaineKinnebrew||Database||Reply||Execute permission||Dieter,
|46426||28 Nov 2014 @ 06:20 PST||VandeBergB||Database||Reply||Fast Load - doesn't load duplicate records in multi set table||By default, FastLoad eliminates duplicate records. The entire row must be a duplicate, not just the PI, the entire row. There is no way to retrieve the duplicate discards.
|46425||28 Nov 2014 @ 05:44 PST||jacek.adamowicz||Tools||Reply||TPT SelectStmt||Hi,
I'm using TPT 14.00.00.03, both on Windows and AIX. I am exporting data using $EXPORT template.
It seems that escaping single quotes by doubling them does not work for SelectStmt. I am no... |
|46424||28 Nov 2014 @ 02:00 PST||ratchetandclank||Tools||Reply||TPT Vs other ETL Utilities||vincent91, Please check "-h" option in the TPT.
|46423||27 Nov 2014 @ 11:58 PST||Harpreet Singh||Database||Reply||Fast Load - doesn't load duplicate records in multi set table||Hi, Please refer http://forums.teradata.com/forum/tools/why-mload-accepts-duplicates-and-why-dont-fastload.
|46422||27 Nov 2014 @ 11:34 PST||DS||Database||Topic||Fast Load - doesn't load duplicate records in multi set table||Hi All,
Want to know why fast load do not load duplicate records in multiset table.
Please give me the reason behind such behaviour
|46421||27 Nov 2014 @ 04:32 PST||Sikee||General||Topic||Write TPT with JCL||Hi Guys,
Can you please help with writing TPT Script with JCL. I have written a TPT script and want to embed it in JCL (Job control language) for mainframe. I have no idea how to do this. If I can... |
|46420||27 Nov 2014 @ 01:18 PST||hema.ananth||Tools||Topic||Teradata Utilities installation||Hi All,
I have installed Teradata Express VMware. Able to connect to the DB using bteq and SQL Assistant.
Now Trying to install Teradata utilities (Windows Client installation Pac... |
|46419||26 Nov 2014 @ 11:28 PST||Harpreet Singh||Database||Reply||How to decide about Stats for new queries||No you cannot check from view directly.
|46418||26 Nov 2014 @ 11:24 PST||Harpreet Singh||Database||Reply||Timestamp and date calculation||Thanks Dieter.
|46417||26 Nov 2014 @ 08:49 PST||amadu||Database||Reply||copy/backup table ||Hi Ulrich - Yes its on the same server.
Thank you for your help.
Alls good with your help.
|46416||26 Nov 2014 @ 06:48 PST||varnas||Database||Topic||Teradata 14 certification Help||Hi,
I am planning to write Teradata 14 certifications. Can any one suggest me which materials are good to study. I am planning to write first 3 exams in next month. Please guide me if you kn... |
|46415||26 Nov 2014 @ 06:30 PST||GianTD||Database||Reply||Identify the queries||I use ODBC.
Query band worked fine,
Thanks ! Ulrich. That solved my purpose.
Comment thing i wanted to check just in case...
|46414||26 Nov 2014 @ 06:07 PST||GianTD||Database||Reply||How to decide about Stats for new queries||Right Harpreet but my question was:
To check about the existing stats on the tables...
- Can we check from views itself used in the query?
(As you need to check definition of each view to find ... |
|46413||26 Nov 2014 @ 03:41 PST||SteveBovy||Tools||Reply||TTP output file not getting zipped when .gz is used as file extension||The zip/gzip support was added to 13.10 in efix 08.
Their were some additional fixes in efix 020. Please upgrade to the currentlatest 13.1o efix.
|46412||26 Nov 2014 @ 02:11 PST||yuvana||Database||Topic||can a Stored procedure can load the data from one view to another view.?||Hi
Can any one confirm me,
1. Is A Stored procedure can load the data from one View to Another VIew?
2. is A stored procedure can load the data from one Table to anothe VIew?
3. Is Stored... |
|46411||26 Nov 2014 @ 11:24 PST||ssurajss||Aster||Reply||Connectivity between Aster 6.0 and HDP 2.1||Hi Aastha,
Even i am facing the same error. Were you able to resolve this issue ?
|46410||26 Nov 2014 @ 09:19 PST||mathanur5||Tools||Topic||TTP output file not getting zipped when .gz is used as file extension||Hello All,
We are trying to create a zipped text file extract from a Teradata table using TPT script. We have named the file as <file_name>.dat.gz but for some strange reasons the out file d... |
|46409||26 Nov 2014 @ 08:19 PST||stahengik||Database||Topic||Import data from SAS using Teradata SQL Assistant||Hi,
We have data in SAS server and we need to get some tables in teradata.
The way we are doing it now is using SAS to write data in teradata database, I want to know if there is way by whi... |
|46408||26 Nov 2014 @ 06:18 PST||firstj||Database||Topic||c / END TRANSACTION - Max. number of statements||Can anyone confirm the max. number of SQL statements that can be run between BT; / ET; statements when running in Teradata V14?
|46407||26 Nov 2014 @ 06:05 PST||hazard01||Database||Reply||select value from string with varying position||Hi there,
I am using version 14 so I will give it a try shortly and let you know. That's a new one on me so thanks for the heads up.
|46406||26 Nov 2014 @ 05:24 PST||Jugalkishorebhatt1||Database||Topic||JOIN INDEXES WITH PRIMARY INDEX||Hello All,
Why we cannot have JOIN INDEXES with UPI/USI. If there is a option to create a Join Indexes with UPI/USI, how can it be done.
|46405||26 Nov 2014 @ 04:21 PST||dnoeth||Teradata Studio||Reply||Increase Java Heap space in OSX Express Studio? ||On OSX the ini file is in the application folder: control click on the application and choose "Show Package Contents" in the context menu.
Then it's in the MacOs folder (you ... |
|46404||26 Nov 2014 @ 04:02 PST||dnoeth||Database||Reply||Teradata Pivot ||Is there Seq_nbr guaranteed to be always in the correct order: 1,2,1,2,1,2,...?
Punch AS Punch_in,
MIN(Punch) -- next value
OVER (PARTITION BY EMP_I... |