#DateForumTypeThreadPost
1613 Aug 2009 @ 10:06 PDTToolsTopicSCD type 2Hi All, How do we implement SCD type 2 in teradata. Thanks, kiran
1513 Aug 2009 @ 09:38 PDTToolsTopicScd type2Hi all,How do we implement Scd type 2 in Teradata.Please let me know the process.Thanks,kiran
1411 Aug 2009 @ 10:50 PDTToolsTopicDifferences between v2r6 and 12Hi All,Please let me know few differences between teradata 6 and 12.Thanks,kiran
1311 Aug 2009 @ 10:39 PDTToolsTopicPerformance monitorHi all,How can we improve performance of a query by seeing performance monitor tool.Thanks,kiran
1211 Aug 2009 @ 10:38 PDTToolsTopicMload IssueHi All,Is there any way to stop mload while it is running.Suppose i am loading millions of records,but unfortunately i dont want to load that records.I want to stop mload.Is it posssible?Thankskiran
1123 Jul 2009 @ 02:20 PDTToolsTopicDuplicates in FastloadHi All,As Fastload does not allow duplicate records. But how to identify the duplicate records, those records were not loaded in errortables.Only on the output screen we can see.Please let me know ...
1023 Jul 2009 @ 02:18 PDTToolsReplyhow does fastload identify duplicates while loading ???Hi All,As Fastload does not allow duplicate records. But how to identify the duplicate records, those records were not loaded in errortables.Only on the output screen we can see.Please let me know...
929 Jun 2009 @ 03:20 PDTToolsTopicPE and AMPHi All,Why a Parsing Engine(PE) and Access Module Processor(AMP) called as Virtual Processors.REgards,kiran
826 Jun 2009 @ 03:43 PDTToolsTopicPerformance TuningHi ,Which tool we can use to do performance tuning in Teradata.As PMON is used to just view the query and to check the status of that query.Regards,kiran
726 Jun 2009 @ 03:41 PDTToolsTopicDifferences between Macro and Stored procedueHi,Can any one please tell me the differences between a Macro and Stored procedue as both contains set of sql statements.Regards,kiran
628 Apr 2009 @ 02:57 PDTToolsReplyMultiple flat files loading into singletable using floadHi,use union transformation in informatica and load the data in to target using fastload external loader.Regards,kiran
528 Apr 2009 @ 02:04 PDTToolsReplyUse of Teradata Fastload external loader using informatica 7.1.3Hi,First you need to configure external loader in workflow manager.Go toworkflow manager->connections->loaderin dialog box select new ,and select teradata fastload external loader and click o...
421 Apr 2009 @ 06:25 PDTToolsTopicDifferences between macro and bteqHi all,Can any one tell me , what is the difference between macro and bteq.As macro contains set of sql statements and bteq also contains set of sql statements.we can have user rights on macro.can ...
315 Apr 2009 @ 11:08 PDTToolsReplydifference betweem v2r5 & v2r6Hi,New features in v2r6:Features for… Performance:Optimize USI Maintenance & Rollback PerformanceOptimize NUSI Rollback PerformancePPI for Non-Compressed Join IndexSimple Update OptimizationFeatu...
210 Apr 2009 @ 04:40 PDTToolsReplyDifferences between bteq and mloadThanks gopi..but still i want some more reasons as BTEQ does error reporting, not error capture.But in mload we can capture in err1 and err2 tables.Is Fastload and Mload errors table are same or di...
109 Apr 2009 @ 03:10 PDTToolsTopicDifferences between bteq and mloadHi all,I am new to Teradata forum.can any one help me when we can go for Bteq and when we can go for mload.Why cant we go for bteq instead of mload and viceversa.Regards,kiran