All forum activity

#DateUserForumTypeThreadPost
5769113 Jun 2016 @ 02:38 PDTkk_newuserDatabaseReplyHow to Reduce Table Space Hi ,  you can decrease the length of the column incase it defined large at the time of table creation than actual data size.  In my project , we have decreased decimal data type and sav...
5769013 Jun 2016 @ 12:35 PDTaneelkumar04DatabaseReplyHow to Reduce Table Space Hi Carlos, Thank you for Response. Compressoin already there. Thank you, Anil
5768913 Jun 2016 @ 12:26 PDTCarlosALDatabaseReplyHow to Reduce Table Space Hi. Compression (in any of the options that Teradata allows) is your best chance. Cheers. Carlos.
5768812 Jun 2016 @ 11:23 PDTPratyus_Vabtos1ToolsReplyTD utilities and JAVA.Hello All,            I am trying to perform dataloading from one teradata db to another teradata db using fastexport and fastload. But i am not being able to underst...
5768712 Jun 2016 @ 11:06 PDTaneelkumar04DatabaseTopicHow to Reduce Table Space Hi Experts, One my of Teradata table occupying 2700.25 GB of Space. I did some intial analysis on this table. I have checked everything looks good i.e Primary index (NUPI), Skew everything fine. I...
5768612 Jun 2016 @ 10:54 PDTkeerthi1987DatabaseReplyNo spool space error,when running SP in BTEQ.Hi, We fetch data from one table and stored that results to global temporary table and we perform some aggregation function and union all the results.Using that result update that into new table. ...
5768512 Jun 2016 @ 09:10 PDTqasimToolsReplyArcmainHi,  I dont have Tays Id, Is there any other way?  
5768412 Jun 2016 @ 04:26 PDTM.Saeed KhurramToolsReplyArcmainHi, If you have access to tays, then you can download the Arcman cleint from downloads on Tays. The installation steps depends on your OS. you will find the installation guide there as well. Br, ...
5768312 Jun 2016 @ 12:56 PDTqasimToolsTopicArcmainHi All,  Kindly anyone can advise me from where and how to install Arcmain?
5768211 Jun 2016 @ 10:44 PDTamitteraDatabaseReplyTPT load in informatica giving CLI ErrorI will take that point but , dont think , it has to do something with the collection of stats, App team is pretty mature and they do take care on this very carefully. normally thier code is just pe...
5768111 Jun 2016 @ 08:21 PDTramesh.bheriDatabaseReplyCalling a teradata stored procedure by shell scriptHi Dieter , thanks for the clarification . My actual requirement is like i wil have a table which contains set of insert statement . I need to run all those insert statements picking one by one f...
5768011 Jun 2016 @ 08:20 PDTPrabhakar ThangapandiDatabaseReplyTPT load in informatica giving CLI ErrorI don't think increasing to 740 might be a good idea. That affect entire database and may risk the whole application. Please see if collect stats prior to load on all invloved table works. Also pl...
5767911 Jun 2016 @ 07:11 PDTamitteraDatabaseReplyTPT load in informatica giving CLI ErrorThe iss for us is relating now at the Login time out issue which we are now recommeding to increasing to 740 sec, as a temp workaround, also there is a patch involved to be done at Informatica serv...
5767811 Jun 2016 @ 07:56 PDTPrabhakar ThangapandiDatabaseReplyTPT load in informatica giving CLI ErrorHi amit, as said earlier collect stats on the source tables helped a bit. But as the volume grew over the period from 40 million to 250,50million, the issue repeated. DBA suggested to use TPT with...
5767711 Jun 2016 @ 07:34 PDTdnoethDatabaseReplyCalling a teradata stored procedure by shell scriptYou can't create SPs in BTEQ like this (but in SQL Assistant). The SP source code must be stored in a file and then it's: .COMPILE FILE = my_sp_source.txt;  
5767611 Jun 2016 @ 04:17 PDTramesh.bheriDatabaseReplyCalling a teradata stored procedure by shell scriptHi All, I'm new to stored procedure in Teradata. Im trying to create a simple store procedure which would insert one record into table using unix script. I'm unable to create as it is thr...
5767511 Jun 2016 @ 03:24 PDTdnoethDatabaseReplyHow to declear Macro Variable?Global and session level parameters in SQL
5767411 Jun 2016 @ 03:19 PDTdnoethAnalyticsReplyHelp extracting select time period records ( rank / any other way)You simply need to check the next row's values: select COLA, COLB, COLC, min(COLB) over (partition by COLA order by COLC) as nextCOLB, min(COLC) over (partition by COLA order by COL...
5767311 Jun 2016 @ 03:13 PDTdnoethDatabaseReplyTERADATA on Windows 10I'm running VMs on three generations of INTEL NUCs using i3 CPUs.
5767211 Jun 2016 @ 03:00 PDTdnoethDatabaseReplyCalling Dnoeth your expert opinion is requried and a easy question. Please respond. Spool/Temp/Perm space is always divided by the number of AMPs in the system Well, the meaning of always implies no exception :)  
5767111 Jun 2016 @ 02:53 PDTdnoethDatabaseReplySubtracting Timestamps as decimals hoursWell, TimeStamp_Diff_Hours <> TimeStamp_Diff_Seconds
5767011 Jun 2016 @ 02:50 PDTdnoethDatabaseReplyCopying trillions of data to new tableThis should run fast as it's based on the partitioning column.  Is there a Join Index defined on the table, can you post Explain?
5766910 Jun 2016 @ 10:30 PDTamitteraDatabaseReplyTPT load in informatica giving CLI ErrorGuys,    Do we have any clue to this issue if it got resolved. We tried checking Informatica/ network  etc. Many blogs suggst its issue at the clinet side i.e configuration etc, b...
5766810 Jun 2016 @ 03:02 PDTInternational83ToolsTopicBTEQ Import Latest Flat FileHello experts, I am using BTEQ and need some help to create a solution to dynamically pick a pipe delimited file based on the latest time stamp. I have heard about the .OS RM command but will dele...
5766710 Jun 2016 @ 02:23 PDTfgrimmerTeradata StudioReplyIs there a way to modify Connection Properties of DB Connections through some external Windows config file?It will import any new connection profiles or overwrite existing ones that match the name. Possibly another option is to modify the host files that map the database server names?

Pages