#DateForumTypeThreadPost
11811 Apr 2012 @ 02:29 PDTGeneralTopicTracking Database Change Requests Has anyone found a tool or product that has assisted them in managing change requests and details for changes to data models, database structures, and/or ETL code for their Teradata Data Warehou...
11709 Sep 2011 @ 08:06 PDTToolsReplyTeradata SQL Assistant JAVA not seeing ODBC connectionsI don't think the Java Edition uses ODBC connections. It uses JDBC connections. I believe there are some embedded drivers but you can also reference the external JDBC drivers as well. Under the ...
11608 Sep 2011 @ 09:51 PDTToolsReplyFastLoad Loop Through Multiple Files for Single TableQ hit the nail on the head with his answer. TPT is perfect for this kind of thing. Another option would be to use some kind of script wrapper (Windows Batch/*nix shell) that could accept the li...
11506 Sep 2011 @ 09:55 PDTDatabaseReplyTimestamp DatatypeMy understanding is the value in the (..) is basically the number of digits for fractions of a second that you want to store. So Timestamp(0) is accurate to the second, Timestamp(1) is accurate to...
11401 Sep 2011 @ 02:29 PDTDatabaseReplyDifference between 2 queriesWell, first you're missing a ")" in the first query. Before the last group by. But to your original question, it appears that the two should return the same result set, although with vastly d...
11301 Sep 2011 @ 09:57 PDTDatabaseReplyhow to hashing primary index valueThis is done automatically. You define a primary index as a set of columns and then when new data is loaded, Teradata will take the values in those columns, apply a hashing algorithm to them, and ...
11201 Sep 2011 @ 09:53 PDTDatabaseReplyTable Growth using dictionary tablesIf you have PDCR implemented, you can look in those tables. It will capture your history of table space as it changes daily and from there you can calculate your growth rate.
11131 Aug 2011 @ 11:33 PDTGeneralReplyModelling Hierarchies with dynamic levelsWe load it using BTEQ and recursive SQL. Our hierarchies aren't that large so it wasn't a performance issue.
11029 Aug 2011 @ 12:54 PDTDatabaseReplyHow to limit the number of rows returnedYou should be able to do what you're asking in Java, not in SQL. There are several parameters on your statement, resultset, or connection that can be defined in JDBC to control how many records ar...
10929 Aug 2011 @ 08:39 PDTGeneralReplyModelling Hierarchies with dynamic levelsOne technique I've used involves something called a "bridge" table. Essentially, we load a dimension table with all of the parent or child objects in the hierarchy. Then, we build this bridge tab...
10829 Aug 2011 @ 07:58 PDTDatabaseReplyPreferred approach to application installation I'd suggest looking at using ant to execute these. There's a nice article on here somewhere that suggests how you would use ant to automate database tasks. It would allow you to define multiple s...
10725 Aug 2011 @ 10:58 PDTDatabaseReplyHandling missing datesFor that, you'll need a list of all of the departments. Do you have a department table? If so, you can include that in as an outer join as well. It will function similarly to the calendar join...
10624 Aug 2011 @ 07:55 PDTDatabaseReplyTeradata Foreign Key side effectsThis is a table for tracking foreign key violations. It exists because you defined "Hard RI", or database-enforced RI. Using Soft RI (WITH NO CHECK OPTION) in your FK declaration will inform the ...
10523 Aug 2011 @ 03:05 PDTDatabaseReplyTable or view that contains the NumberOfRows & NumberOfColumns?Column information is stored in DBC.Columns. SELECT DatabaseName, TableName, COUNT(*) AS NumberOfColumns FROM DBC.Columns GROUP BY 1,2; will give you the NumberofColumns. DBC doesn't store row co...
10412 Aug 2011 @ 09:27 PDTDatabaseReplyIssue when exporting data to Excel using Bteq This may just be a display issue in Excel. Try playing with the format of that column and change it to Text or something other than numeric. This should force them to display the leading zeroes. ...
10311 Aug 2011 @ 09:50 PDTViewpointTopicMultiple Portlet InstallationsWe only have a single Viewpoint system and I've had less than stellar success getting the PDK sample Viewpoint instance up and running and I need the ability to test changes to an existing in-use p...
10203 Aug 2011 @ 02:44 PDTDatabaseReplyUDF's for column securitySomething like this. REPLACE VIEW DB.MaskView AS LOCKING ROW FOR ACCESS SELECT Column1 ,Column2 ,CASE WHEN USER IN ('User1','User2') THEN '*********' ELSE Column3 END AS MaskedColumn FRO...
10103 Aug 2011 @ 08:56 PDTDatabaseReplyData Cleansing using SQLRestore from backup? Unfortunately, I'm not sure there is a good option here. What column(s) make up your primary key of this table? Is there a process that introduces this kind of error? Can y...
10002 Aug 2011 @ 07:47 PDTToolsReplyPerformance TuningWhat error are you getting exactly? In general you should collect statistics on columns used in joins and WHERE clauses.
9928 Jul 2011 @ 08:19 PDTUDAReplyKey Level DuplicatesOK. I think I understand better what's going on now. You just want to get the first occurance (for some definition of first) for each key value pair, regardless of how many rows have that key. ...
9825 Jul 2011 @ 01:03 PDTDatabaseReplyHow to import data from Oracle using SQL AssistantYour input needs to be a file and it needs to be some form of delimited. In the SQLA options, you can specify the delimiting character. I think the default is | but I could be wrong. Once you've...
9725 Jul 2011 @ 09:53 PDTDatabaseReplyCalling Only Closed RecordsI'm not terribly familiar with the temporal keywords. I've only experimented with them a little, but couldn't you do basically what you describe in the last sentence? Could you construct a query ...
9625 Jul 2011 @ 09:49 PDTDatabaseReplyCompare database between prod and devWell, AtanaSuite has a tool called the Delta Tool that does exactly this. You point it to the source (reference) and target (comparison) systems, specify the database(s) you want to compare and ch...
9522 Jul 2011 @ 09:51 PDTConnectivityReplyidentify which jobs make a connection to a specific Database sourceYou have to enable DBQL Object Logging in Teradata. Work with your DBAs to get that done.
9422 Jul 2011 @ 08:00 PDTDatabaseReplyQuery on Collect statsFirst, I'm guessing that's a typo in your query and the last line should read and T1.Col2 = T2.Col2; ;) Carrie Ballinger has some good blog posts on this site about statistics and multi-column ...

Pages