All forum activity

#DateUserForumTypeThreadPost
5871925 Jul 2016 @ 10:27 PDTFredToolsReplyUpload files .dat in Teradata They are separate batch-oriented client utilities, unrelated to SQL Assistant.
5871825 Jul 2016 @ 10:16 PDTNavicDatabaseReplyData migration between 2 different BoxesThanks Carlos, Teradata Versions are smillar, but Number of AMP's are not same.
5871725 Jul 2016 @ 09:46 PDTtjmunsonConnectivityReplyConnectivity issues for SQL Assistant 15For whats its worth, I had the same issue when installing 15.10 and had uninstalled TTU 14 before the 15 install.  After reading this entry, I removed the 15.10 TTU and installed TTU 14.&...
5871625 Jul 2016 @ 09:24 PDTValeriaToolsReplyUpload files .dat in Teradata Hello Fred, a question concerning this topic. Teradata Parallel Transporter, BTEQ, FastLoad, MultiLoad are programs thatI have to download to be used with SQL Assistant or are kind of SQLs that al...
5871525 Jul 2016 @ 09:06 PDTCarlosALDatabaseReplyData migration between 2 different BoxesHi. arcmain dump + arcmain restore / copy should work, but you must take care of things such as if the systems are same version, number of AMPs, etc... You should review the documentation before ...
5871425 Jul 2016 @ 08:43 PDTCarlosALDatabaseReplyMerge into operationHi. Teradata MERGE INTO DOES NOT require a primary key. It requires that the target  table PRIMARY INDEX columns (and partitioning columns if PPI) are present in the match condition (equality...
5871325 Jul 2016 @ 07:10 PDTM.Saeed KhurramDatabaseReplyFastloadIt is the target table that gets locked, error tables are available to analyse the issues. Can you share the falstload job logs to understand the issue properly.  
5871225 Jul 2016 @ 06:51 PDTabhishank18DatabaseReplyFastloadBut again fastload script can only run if there is no issue in the data and if that is resolved error tables are dropped. For instance, if data has a UPI voilation then this row will go into the er...
5871125 Jul 2016 @ 06:37 PDTM.Saeed KhurramDatabaseReplyFastloadThese error tables are dropped by default if there are no error records in these error tables.  The tables are retained only when the there are rows in error tables. Duplicate records are si...
5871025 Jul 2016 @ 06:27 PDTM.Saeed KhurramDatabaseReplyMerge into operationMerge Statement requires Primary Key in its condition regardless of Index. If it is not possible to define a primary key for the table, you can not use merge syntax. you can try Upsert syntax ins...
5870925 Jul 2016 @ 06:20 PDTabhishank18DatabaseReplyFastloadBut after resolving the issue in the script or in the data , once the script runs fine these error tables will be dropped. So when can we actually utilize these error tables ?
5870825 Jul 2016 @ 06:14 PDTM.Saeed KhurramDatabaseReplyFastloadYou can see the entries in error tables, but right now you have issue in your script, that's why error tables are not accessible. You can use these queries to see the data in error tables: se...
5870725 Jul 2016 @ 06:08 PDTabhishank18DatabaseReplyFastloadSo there is no way using which we can directly see the entries made in the error tables ?
5870625 Jul 2016 @ 06:02 PDTM.Saeed KhurramDatabaseReplyFastloadThe load is paused when there is some issue in the script. Error tables only capture the issues in data. To rectify the issue, go through the Fastload script log. You can create the loag file as f...
5870525 Jul 2016 @ 05:57 PDTM.Saeed KhurramDatabaseReplyHelp needed for understanding of space default behavior and limitations or rulesQ1- If you do not specify spool and temp space, it will inherit the spool and temp space of parent that is A1 so the spool and temp space for A11 will be: Spool = 100 GB Temp = 100 GB Q2- This w...
5870425 Jul 2016 @ 05:52 PDTM.Saeed KhurramTeradata Database on VMWareReply"How to download TTU for fixing the bteq issue on mac"Hi, We faced this issue on AIX, the issue ocuurs due to incorrect settings and sequence of environment variables. Follow the environment variables instructions in the installation of TTU. Otherwi...
5870325 Jul 2016 @ 05:50 PDTabhishank18DatabaseTopicFastload Is there any way to access the Error Tables in case there is an error while fastload process, As selecting from error table throws an error saying table is being loaded ? If not how can we know ...
5870225 Jul 2016 @ 05:19 PDTagtsDatabaseTopicHelp needed for understanding of space default behavior and limitations or rules Existing Database   Database Name = A1 Perm Space    = 100 GB Spool Space   = 100 GB Temp Space    = 100 GB     CREATE DAT...
5870125 Jul 2016 @ 05:07 PDTVandeBergBDatabaseReplyDBQL MetricsI'm not Dieter... and i don't play him on TV, but to answer your question, The ...Norm columns are intended to be used in co-existence systems, multiple generations of hardware in one syste...
5870025 Jul 2016 @ 04:27 PDTvenkata_k01DatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousThank you very much Carlos. Its working :) Thank you Shardful for elaborating my requirement.
5869925 Jul 2016 @ 01:36 PDTbharathraoGeneralReplyinterview helpHi, Please share me the questions @ bharathrao.44@gmail.com
5869825 Jul 2016 @ 12:39 PDTshankar.lingaTeradata Database on VMWareTopic"How to download TTU for fixing the bteq issue on mac"Hi, I have installed vmware and trying to load data from local machine to vmware datbase(TD Express) but bteq is not working in local machine due to below error  *** CLI error: MTDP: EM_G...
5869724 Jul 2016 @ 11:50 PDTpvharikumarGeneralTopicContinuous Integration On Teradata systemHi,   We are currently analyzing the feasibility of implementing Continuous Integration in our datawarehouse which uses Teradata and Informatica ETL tool. Does anyone have details on implemen...
5869624 Jul 2016 @ 11:45 PDTArunkumargyaraDatabaseReplyDBQL MetricsHi dieter,   could you please help me to understand how AMPCPUTIMENORM, MAXAMPCPUTIMENORM and MINAMPCPUTIMENORM is calculated. And how it differs compared to AMPCPUTIME.
5869524 Jul 2016 @ 11:05 PDTSoumyatgDatabaseReplyConsequential inserts into large fact table performing very slow inside stored ProcedureThanks Dieter. but the target table is already populated even in the 1 st insert , its not an empty table. Still I can see that the 1st insert is actually better. If I pull all the inserts into 1 t...

Pages