47302 Feb 2014 @ 04:04 PSTDatabaseReplyHow can I install teradata express without VT support since I don't have windows version of teradata express download link?Teradata express for windows has been not around for some time now, you can use VMWare image. It is available in different sizes (4GB 40Gb, 1TB).
47202 Feb 2014 @ 04:02 PSTDatabaseReplyHow can I install teradata express without VT support since I don't have windows version of teradata express download link?VT Support?
47102 Feb 2014 @ 12:46 PSTDatabaseReplySpace in the databaseIf the perm-space is zero, user usually fly off the planet.   Answer is B & C, as perm-space has nothing to do with data-access rather its for data-storage.
47002 Feb 2014 @ 12:37 PSTDatabaseReplyConverions of timestamp to FORMAT 'MM/DD/YYYYBHH:MI:SS' You have 1 extra ')' just before AS TIMESTAMP(0):   Correct: CAST(SUBSTRING (CAST (A.DW_LOAD_TMP AS VARCHAR(19)) ,1,19) AS TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SS&#...
46902 Feb 2014 @ 12:29 PSTDatabaseReplyTeradata Spool issue in Recursive issueWhat exactly do you mean by 'While as per requirement no duplicate allowed in the resiliation column.'? Duplication of values as a chunk or individual values?
46802 Feb 2014 @ 12:08 PSTDatabaseReplySQL WorkaroundSounds like a very nice project.   I would start by analyzing each query and noting about underlying tables, data volumes, PIs, PPIs, Joins, Joining columns, Data-types of joining columns, e...
46702 Feb 2014 @ 12:03 PSTDatabaseReplyCan 'INSERT INTO' statement handle duplicates?Which underlying tables are you using .... SET or MULTISET?
46602 Feb 2014 @ 12:02 PSTDatabaseReplySelection of Primary index On a very high level, for data loading you need to select column(s) giving you the unique values for most of data .... for accessing the data you need to select column(s) causing minimum re-dist...
46501 Feb 2014 @ 11:54 PSTDatabaseReplyFormatting CURRENT_TIMESTAMPYou dont need to cast to varchar/char if you are connected via CLI .... it is required on ODBC connectivity.
46401 Feb 2014 @ 11:26 PSTDatabaseReplyUDF in teradataSource code of UDF is a C++ code or SQL code, binary file must be the compiled form. What is the source of this .o file?
46301 Feb 2014 @ 11:24 PSTDatabaseReplyDeadlocks whenusing Teradata with InformaticaHow is your workflow arranged? Ideally it should be managed there to ensure flows having same target table are sequenced.
46201 Feb 2014 @ 09:37 PSTDatabaseReplyNear Real Time Stored Procedure Architecture FrameworkIdeally, you need to bring in data in TD before you could get the benefits of SP. The name 'Near real-time architecture' suggests you should be using tpump to trickle the data from source t...
46101 Feb 2014 @ 09:23 PSTDatabaseReplyParsing Engine is taking long time to parse a query !!!How are you managing the rights for users/roles?
46001 Feb 2014 @ 01:08 PSTToolsReplyTeradata SQL Assistant 13.10 (ODBC version) - DownloadSQL Assistant doesnt have seperate versions i.e. ODBC or .NET .... single version works for both.   Also, TDU 14.* will work just fine as they are downward compatible. In case you specifical...
45931 Jan 2014 @ 11:14 PSTGeneralReplyarcmain download linkYour best bet is to contact your DBA.
45831 Jan 2014 @ 11:12 PSTGeneralReplyfs-ldm and tsysI dont think you can get that information publically.
45731 Jan 2014 @ 09:00 PSTDatabaseReplyFORMAT option in create tableSQLA/ODBC converts the formats to local system's format. You can still view the actual data stored using BTEQ/CLI connectvity.
45631 Jan 2014 @ 08:59 PSTDatabaseReplyPlease share any possibility approach with automated process for 2500+ Teradata tables. UrgentAnd it would be better to start at the LDM level, to ensure consistency across all tables.
45531 Jan 2014 @ 08:57 PSTDatabaseReplyQuery OptimisationIntermediate tables seem the best option in this scenario. You havent shared row-counts/time its taking.
45431 Jan 2014 @ 08:52 PSTDatabaseReplyGenerating Surrogate Key Using ROWNUMPlease share your DB.table-names & current/expected row-counts to better propose a solution.
45331 Jan 2014 @ 08:51 PSTDatabaseReplyQuestion regarding FastloadIts a limitation of FL, you need to have a newline character at the end of file. What is the source of your file or are you fetching it from some DB yourself?
45231 Jan 2014 @ 08:49 PSTDatabaseReplySql helpCan you also share the sample output against the sample values, to better understand what you require.
45131 Jan 2014 @ 08:47 PSTDatabaseReplyGenerate SurrogateKey with a huge tableIs there any compulsion in using ROW_NUMBER?   From my experience, CSUM and ROW_NUMBER can cause the response time to slow-down considerably.   For smaller tables they work fine, but ...
45022 Aug 2013 @ 04:41 PDTDatabaseReplyMigrating From Oracle To Teradata Help With DDL GenerationIf not willing to use any other software .... no other option. You must do data-type conversion and index changes manually.   HTH!   Regards.
44922 Aug 2013 @ 04:37 PDTDatabaseReplyDistinct in Case clausePlease share the desired output of the dataset as well.