#DateForumTypeThreadPost
1906 Nov 2009 @ 11:59 PSTToolsReplyCan I rollback in ANSI mode without Transient Journel?Hi JimThanks For the Reply...What exactly I'm looking at is...is there any alternative method to perform ROLLBACK operation if transient Journels are not taken on target table...
1806 Nov 2009 @ 02:59 PSTToolsTopicCan I rollback in ANSI mode without Transient Journel?Can I rollback in ANSI mode without Transient Journel?I have a requirement to update a table...if the number of records which are updated is not matched with the intended number of records it shoul...
1706 Nov 2009 @ 11:18 PSTToolsTopicANSI Mode BTEQ ScriptHi All,I need to write one Bteq script to update my table.Along with this I need to take the number of records it is going to update by running select statement before Update statement.Once update ...
1606 Nov 2009 @ 11:17 PSTDatabaseTopicANSI mode BTEQ ScriptHi All,I need to write one Bteq script to update my table.Along with this I need to take the number of records it is going to update by running select statement before Update statement.Once update ...
1516 Sep 2009 @ 09:40 PDTToolsReplyCAN I WRITE ERRORED RECORDS INTO A FILE IN MLOAD?Thanks Jimm..It really helped me a lot!!!!
1416 Sep 2009 @ 07:22 PDTToolsReplyCAN I WRITE ERRORED RECORDS INTO A FILE IN MLOAD?I got the solution to write the error messages to a file..But what I am looking for is...Can I write the errored records into a file?Thanks In Advance
1316 Sep 2009 @ 05:42 PDTToolsReplyCAN I WRITE ERRORED RECORDS INTO A FILE IN MLOAD?Thank You Very Much Steve for the reply...Steve..I tried running the below script through Informaticamload /Informatica/TgtFiles/error_TEIS_CRMC_CU_PSTL_PERS_ORG_NM.outI though that, only errrore...
1216 Sep 2009 @ 05:38 PDTToolsReplyCAN I WRITE ERRORED RECORDS INTO A FILE IN MLOAD?Thank You Very Much Steve for the reply...Steve..I tried running the below script through Informaticamload error_TEIS_CRMC_CU_PSTL_PERS_ORG_NM.outI though that only errrored records information w...
1104 Sep 2009 @ 09:56 PDTToolsTopicCAN I WRITE ERRORED RECORDS INTO A FILE IN MLOAD?Hi ALL,While loading data from flat file to Teradata table using MLOAD,few records has bad data.Due to these records MLOAD got failed and this data hasn't been captured in ET tables.So I have used ...
1004 Sep 2009 @ 09:50 PDTToolsTopicCan I Write Errored Records into a File In MLOAD?Hi ALL,While loading data from flat file to Teradata table using MLOAD,few records has bad data.Due to these records MLOAD got failed and this data hasn't been captured in ET tables.So I have used ...
921 May 2008 @ 12:27 PDTDatabaseTopicHow can we convert product join into a merge join?When I take explain plan for a query....it is showing that few joins r "PRODUCT JOINS"..because of this that qry is taking much time ..So I want to convert into Merge Join...How can I do this?Your ...
817 Apr 2008 @ 01:15 PDTToolsTopicsample FLOAD,MLOAD and FAST EXPORT scriptscan anyone please provide few example scripts for FLOAD,MLOAD and FAST EXPORT...Thanks In Advance
715 Apr 2008 @ 07:04 PDTToolsReplyFast Export Script Syntax.LAYOUT Control ;What this line do? Is Control a keyword or user defined word?And this Layout is input file Layout or the layout of the file to which output is export?Thanks in Advance..
615 Apr 2008 @ 06:58 PDTToolsTopicFast Export Script Syntax.BEGIN EXPORTSESSIONS 20;.LAYOUT Control ;.FIELD Date1 * Date ;.FIELD Date2 * Date ;.IMPORT INFILE InNameLAYOUT Control ;.EXPORT OUTFILE C:\outputtext.txt ;SELECTRegion,ProdCode,From TranLogTableWH...
510 Apr 2008 @ 12:04 PDTDatabaseTopicIs Hashmap for both PI and SI same or different?In message passing layer we have a HAshMap....Is this same for both SI and PI?If so why do we need the subtable for SI?We can directly access the base-table from the row hash generated by the has a...
408 Apr 2008 @ 04:20 PDTUDAReplywhy Stored Procedure saved in Permanent Space ? Why not Macro?Thanks a lot Mr.Dieter..
304 Apr 2008 @ 08:47 PDTUDATopicDifference between Secondary Index and Hash IndexCan anyone expain the diff b/w Secondary Index and Hash IndexAlso In which scenario we will go for Hash Index?...
204 Apr 2008 @ 05:31 PDTUDATopicwhy Stored Procedure saved in Permanent Space ? Why not Macro?Hi All,Can any one tell me why stored procedure saved in Perm space, but Macro is not saved in perm space...As both are doing the same job why they r not saved in the same place....Any clue?Regards...
122 Nov 2006 @ 06:49 PSTDatabaseTopicTERADATA SQL MATERIALHi All, I am very new for this Teradata Database. I have to work on it as my projects backend is Teradata. So I request you to please provide some Teradata SQL related material...