4504 Feb 2016 @ 11:40 PSTDatabaseReplyFind Only DuplicatesHi AG, As not chk had been set while populating the data hence what ever you do can not prevent this senarion to happne in near future. Comming back to your question It have to be a all amp operat...
4413 Jul 2015 @ 09:53 PDTGeneralTopicWhile Joining A Number of tables on Multiple ColumnsHi, I faced One issue Couple of Days Back While Creating a Desired Out Put We had To Join 6 Tables Over 27 Columns. Ended Up as a Spool Space Issue. I Dig Further The reason was Data was Trying to...
4323 Apr 2015 @ 04:37 PDTGeneralTopicWhile Joining Two table On PRIMARY INDEX and Secondary INDEXHi, While we are joining two tables Table A and Table B, are joining on Column C . In Table A , column C is Primary Index and In table B it is a Secondary Index. WIll it be the same senario if co...
4202 Apr 2015 @ 09:49 PDTDatabaseReplyHow to find the Object IDs form DBC where it is stored.DBC always keeps a track of the objects and id corresponding to it, as per my understanding. even elemts like ProcsRowLock, TempTableId,StatusQRYID etc are get tracked, my objective is to find till...
4130 Mar 2015 @ 11:06 PDTDatabaseTopicHow to find the Object IDs form DBC where it is stored.How and where Objects are stored and where IDs corresponding to them are stored?
4030 Mar 2015 @ 11:00 PDTGeneralTopicAlong with TeradataHi All,   Not sure where this topic can be covered, thats why posting it under General Tab. Along with Teradata What ETL tool, and What Reporting tool should give you added advantage not onl...
3905 Sep 2014 @ 07:09 PDTTeradata ApplicationsReplyFASTEXPORT - Sorted order two further distribution between amps. But Why?Thanks! Dieter, Thanks! Raja
3804 Sep 2014 @ 07:54 PDTTeradata ApplicationsTopicFASTEXPORT - Sorted order two further distribution between amps. But Why?In fast Exprot If we order SORTed way two further Distribution between amps will be required. But Why?
3703 Sep 2014 @ 06:53 PDTTeradata ApplicationsReplyFASTLOAD / MLOAD Data Parcel How to See what inside?Thanks!
3602 Sep 2014 @ 09:45 PDTTeradata ApplicationsTopicFASTLOAD / MLOAD Data Parcel How to See what inside?Hi, In FLOAD and even MLOAD in ET_TARGET_TABLE, in case off error we get data Parcel. But How to analyse it? How to see what inside?   Thanks! Sankalp
3521 Dec 2013 @ 08:53 PSTAnalyticsReplyFASTEXPHi! Raja, any idea how we can make it dynamic? rather pre-defining it .  
3420 Dec 2013 @ 05:56 PSTAnalyticsReplyFASTEXPsure!
3319 Dec 2013 @ 10:39 PSTAnalyticsReplyFASTEXPis it possible to exprort multiple files depending on number of entries from a single table with fastexport?
3219 Dec 2013 @ 10:37 PSTAnalyticsTopicFASTEXP
3117 Dec 2013 @ 05:43 PSTAnalyticsReplyWhy FastLoad Does not support NUSI ?thanks! dieter thanks! tom  
3017 Dec 2013 @ 08:52 PSTAnalyticsTopicWhy FastLoad Does not support NUSI ?The question that is hounting my mind now a days is - Why Fastload does not support NUSI on table? The popular ans which I came across is - in case of NUSI to table are there 1. The target table 2...
2917 Dec 2013 @ 08:42 PSTTeradata ApplicationsReplyLimit on a tablethanks! raja Thanks! dieter for your kind attention.
2816 Dec 2013 @ 06:37 PSTTeradata ApplicationsReplyLimit on a tableYes, 5 million is the volume constraint. Or you can think I do not want data which is more than 1 yr old in Tab1. it should be passed to tab2( rather a history table by nature.).
2716 Dec 2013 @ 06:34 PSTAnalyticsReplyFast Load Vs MultiloadThanks! Rajat. Thanks! Ulrich. Thanks! khurram.
2616 Dec 2013 @ 09:26 PSTAnalyticsTopicFast Load Vs MultiloadIn case of ideal senario for FastLoad why do we consider Fastload instead of Multiload where both are Bulkload(64kb). Correct me if I am wrong, the populare answer I got is is Fast Load use 2 phaz...
2516 Dec 2013 @ 09:17 PSTTeradata ApplicationsTopicLimit on a tableMy senario is like - I have two table Tab1 and Tab2. Incase, I Tab1 can't have more than 5 milion entries, incase of any thing more old data should be passed to Tab 2.   How to do it in...
2416 Dec 2013 @ 09:12 PSTAnalyticsReplyWhy UV in MLOAD?Thanks! Dieter
2315 Dec 2013 @ 02:28 PSTDatabaseReplyGet the previous row's column ValueAwesome! dieter
2215 Dec 2013 @ 02:10 PSTAnalyticsReplyWhy UV in MLOAD?no doubt.
2113 Dec 2013 @ 12:16 PSTAnalyticsReplyWhile we add New AMPPerfect! :)