#DateForumTypeThreadPost
1011 Jun 2016 @ 08:20 PDTDatabaseReplyTPT 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...
911 Jun 2016 @ 07:56 PDTDatabaseReplyTPT 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...
810 Mar 2016 @ 10:31 PSTDatabaseReplyTPT load in informatica giving CLI ErrorAh... Almost 3 years... Had hard time to recollect.... Yes we did resolve this issue. We added to collect statistics before the load on source table which is the stage table and I think the job ra...
722 May 2014 @ 07:38 PDTDatabaseReplyIssues with Teradata Parallel Transporter(TPT) with Informaticajhaamresh,   For 1) I have faced this issue, to resolve, use Ltrim(rtrim(port)), right before loading it into the target. I tried several other options, but this one fixed/resolved my proble...
601 May 2013 @ 12:27 PDTDatabaseTopicTPT load in informatica giving CLI ErrorHello, Greetings.... I am loading Teradata (V13.10.03.08) database using informaticav9.1.0 (with Hotfix1). In Infa, i am using TPT connection. I have the follwing property on the TPT Connection ...
509 Nov 2012 @ 12:26 PSTToolsReplyData Overlapping in table while using TPT connectionJust updating my post. I fixed the issue by using ltrim and rtrim on all the string columns. I am still unclear that this issue was casued by Informatica or by using TPT connection. --Thread Clos...
409 Nov 2012 @ 12:24 PSTDatabaseTopicLeft outer join with a NULL valueHi, Can some one tell me, how to join 2 tables where one of my table join condition is having a null value. For example, i took some sample values and what i need is given below as output. Table...
315 Aug 2012 @ 10:06 PDTToolsTopicData Overlapping in table while using TPT connection Hi,   I am using Informatica 8.6 and TPT connection to write data into the target table. The stage table loads fine without any issue. Using the same kind of TPT connection, I read ...
209 Aug 2012 @ 02:35 PDTToolsReplyAlter table to add column after specific column Thanks Rob.
102 Aug 2012 @ 12:19 PDTToolsTopicAlter table to add column after specific column Hi, I have to add a new column into an existing table. Is there a way to add a column after a specific column name. For example, my table has 20 columns and i have to add a column after ...