#DateForumTypeThreadPost
1516 May 2012 @ 08:21 PDTGeneralTopicbooks or material training for datastage jobs and teradata sql good morning Im new at Teradata and i need your help In order to get started could you tell me exactly the name of some good books  about creating Datastage jobs (sqn, prl) and Info...
1427 Feb 2012 @ 02:39 PSTDatabaseTopicEntity-Relation Model for Teradata Query Good afternoon Is there any command (Preferred) or any tool to know the relations among specified tables or views I.E. Parent table  record (Product) has -> (...
1324 Feb 2012 @ 09:39 PSTDatabaseReplyhow do i get the top of the most frecuently accesed or used tables OK, Thanks for yor help, and i run the query select top 10 * from DBC.Tables order by 19 desc The 19 number is the positional column for accesscount column But as you mentio...
1219 Feb 2012 @ 04:25 PSTDatabaseTopichow do i get the top of the most frecuently accesed or used tables Good evening Im new a Teradata Database, and i need your help: Id like to know the 20 top most accesed or used tables for a specified database. Is there any way to know by means of ...
1130 Dec 2011 @ 01:05 PSTGeneralTopicexplanation of variables and query in Teradata Good afternon :   Im new at Teradata and Could anybody explain to me what this query does ?   i dont understand the sentence Using _spVV3 (DATE)LOCKIN...
1019 Dec 2011 @ 04:48 PSTGeneralTopicUnderstanding the expression USING _spVV0 (DATE)LOCKING TABLE DWH_DATA.ACCT ACCESS Good evening Im new at Teradata but in in Teradata Manager Tool in the explain tab i stumbled with the expression: USING _spVV0 (DATE)LOCKING TABLE DWH_DATA.ACCT ACCESS ...
902 Nov 2011 @ 02:41 PDTGeneralTopicManaging Datastage Applications for execution Good afternoon   I need your help please: Let me describe briefly the scenario to understand better my concern: In a Datastage application there are 1 sequential jobs and ab...
831 Jul 2011 @ 03:51 PDTConnectivityTopiccannot find entries for file .odbc.ini to acces oracle databasesGood afternoon In Datastage as ETL tool i can connect to differeny RDBS and checkup its configuration by means of .odbc.ini file But checking out this file i can see entries for relevant inf...
725 Jul 2011 @ 07:20 PDTGeneralTopicETL extracting info from didderenet data sourcesGood morning, is any command or like a select statement or code that allows me to see which job is accessing a specific database source into the ETL context.? Therr are hundred of jobs extractin...
622 Jul 2011 @ 08:09 PDTConnectivityReplyidentify which jobs make a connection to a specific Database sourcethanks for your help but how do i turn on DBQL Object Logging in designer ? in system tables with the user DBC is there any poibility?
521 Jul 2011 @ 08:08 PDTConnectivityTopicidentify which jobs make a connection to a specific Database sourceGood evening Im a dummy about Teradata and i have a question in an Production system there are a lot of process that extracts information from heterogenous and operational database system. ...
420 May 2011 @ 10:57 PDTDatabaseTopicis there another tool to kill sessions instead Teradata Manager?good afternoon In the production system, we've got a tool for monitoring database sessions and we can kill those blocking sessins. this tool is Teradata Manager. But the bottleline comes up whe...
311 May 2011 @ 01:42 PDTGeneralTopicdatastage command shell or dsshGood afternoon im new at datstage but i have some questions about it when using dssh, what it is used for generally speaking? 1. can i connect to a teradatata database and make some querys...
219 Apr 2011 @ 02:47 PDTGeneralReplyselect command using BTEQ is not returning all fieldsSomething to say? Add your comment here.
119 Apr 2011 @ 02:46 PDTGeneralTopicselect command using BTEQ is not returning all fieldsGood morning: i need your help: i've got 2 questions: the first one is: i use bteq to connect to Teradata and i want to select the first 5 records of a table but returned just 2 columns. ...