|36941||08 Dec 2013 @ 09:27 PST||astrsteev||Training||Topic||SAP MM Online Training||SAP MM Online Training by Biginfosys We are providing excellent SAP MM Training by real-time
IT industry experts Our training methodology is very unique Our Course Content covers all the in-
|36940||08 Dec 2013 @ 09:22 PST||Raja_KT||Database||Reply||Merge statement showing 0 records merged||Hi,
What you can do is take both the codes of DBA and your code and execute in bteq in unix/linux and see the results and compare if they match. I always trust Unix/linux more.
Second, then... |
|36939||08 Dec 2013 @ 08:45 PST||kw||Database||Reply||Merge statement showing 0 records merged||This is the normal behaviour for the MERGE statement - by accident or deisgn I'm not sure.
|36938||08 Dec 2013 @ 08:38 PST||Raja_KT||Database||Reply||Merge statement showing 0 records merged||Hi,
Few things that come to my mind maybe, just to narrow down the search:
It was executed in a different environment, DBs etc, with data being available in one and not available in another.
|36937||08 Dec 2013 @ 01:31 PST||raghavendra16||Database||Topic||Teradata training hyderabad||Any good teradata training in hyderabad ?
|36936||08 Dec 2013 @ 05:19 PST||Soumik||Database||Topic||Merge statement showing 0 records merged||Hi all,
I have been recently facing an issue while asking TD DBAs to execute a MERGE statement.
Everytime a merge statement is executed by them, it shows 0 records MERGED, whereas while cro... |
|36935||07 Dec 2013 @ 07:29 PST||uco||Database||Reply||Default date column not aligning in xcel||Thanks Dieter for your explanation, thanks everyone . As said by Siddiqui, Dieter it is issue with excel
Dieter , I took the date values from the CSV file created by BTEQ script .
|36934||07 Dec 2013 @ 05:44 PST||VandeBergB||Database||Reply||TD14.10 feature experience ||We just finished a multiphased upgrade to 14.10/SLES11 on 6680's that were previously running 13.10/SLES 10. We've had no issues with anything running at all. Our pre-upgrade testing ... |
|36933||07 Dec 2013 @ 09:25 PST||Puvvadiraja||Training||Reply||Teradata Training Material available||Hello Todd
could you send the material to email@example.com
|36932||07 Dec 2013 @ 08:03 PST||Shrinivas.Sagare||Database||Topic||TD14.10 feature experience ||Hello,
Is there anybody who have upgraded system to TD14.10? How are your experiences with different TD14.10 features? In 14.10 release definition it is written that 14.10 needs more memory per no... |
|36931||07 Dec 2013 @ 06:00 PST||Santanu84||Database||Reply||TD Lock Upgrade and Downgrade Options||Thanks dnoeth for your reply.
|36930||07 Dec 2013 @ 04:35 PST||Sankalp.C||Analytics||Reply||Merge Joining on non-indexed column.||Thanks! Dieter.
|36929||07 Dec 2013 @ 02:19 PST||dnoeth||Database||Reply||Default date column not aligning in xcel||Hi uco,
the sample data is not from a file created by BTEQ, a FORMAT 'DD/MM/YYYY' will never create single digit month/day values.
When you import the data into Excel it will automat... |
|36928||07 Dec 2013 @ 02:13 PST||dnoeth||Analytics||Reply||Merge Joining on non-indexed column.||There's no situation where a Merge join is unavoidable :-)
Merge Join is only one possible way for the optimizer to do a join, there are always others like Product or Hash Join.
But stats on ... |
|36927||07 Dec 2013 @ 02:03 PST||dnoeth||Database||Reply||TD Lock Upgrade and Downgrade Options||Hi Santanu,
there's no automatic downgrade. When you request a READ lock you get a READ lock, the session will be blocked until the other session commits.
You can check if the request will be... |
|36926||06 Dec 2013 @ 11:49 PST||Santanu84||Database||Topic||TD Lock Upgrade and Downgrade Options||Hi
In a script, at Session level the transaction isolation is set to RU (Read Uncommitted or ACCESS).
At table level I am overriding to READ lock for Table1 in a SQL select.
Now if there... |
|36925||06 Dec 2013 @ 08:43 PST||Sankalp.C||Analytics||Reply||TeraData Tuning||Thanks! alevai
|36924||06 Dec 2013 @ 08:42 PST||Sankalp.C||Analytics||Topic||Merge Joining on non-indexed column.||In a situation when Merge Joining is un-Avoidable on non-indexed column, Is using Collect Stats on those column is of any use.
|36923||06 Dec 2013 @ 08:21 PST||Raja_KT||Database||Reply||backup or archive command||
Backups and recovery are the strong points of Teradata. You can dump and restore data, with many check conditions as per your requirements.
Unlike other v... |
|36922||06 Dec 2013 @ 07:54 PST||Raja_KT||Database||Reply||Default date column not aligning in xcel||Hi,
Did you use a trim function? Maybe it will help. Else in excel, you can write a formula or program for those dates where you see they are not proper.
|36921||06 Dec 2013 @ 04:10 PST||gryback||Analytics||Reply||-----Aggregate Designer----||There is a Teradata Aggregate Designer User Guide you can request that provides more detailed information. Please check with your Teradata contact for further details. The software is an orderable ... |
|36920||06 Dec 2013 @ 03:49 PST||uco||Database||Reply||Default date column not aligning in xcel||That may be true, but I am converting it to varchar before exporting , it is not a date anymore right?
thanks for the help
|36919||06 Dec 2013 @ 02:11 PST||Kawish_Siddiqui||Database||Reply||Default date column not aligning in xcel||Excel doesn't support date before 1900 and considering this value as text value.
See for further details : http://exceluser.com/formulas/earlydates.htm
|36918||06 Dec 2013 @ 01:57 PST||dnoeth||Database||Reply||Default date column not aligning in xcel||This is probably because Excel can't handle dates before 1900, regardless of how it's formatted. You can only use that date as a string.
|36917||06 Dec 2013 @ 01:30 PST||TrackingDaily||Database||Topic||backup or archive command||Does Teradata DBMS have a command-line function for creating offline backups, something roughly equivalent to "pg_dump" for Postgres or "mysqldump" for MySQL ?
Or perhaps a GUI-based backup, lik... |