DSXchange

Hi, I have a file of 850MB , XML file exported using Datastage and am trying to import the same to another system and when i am doing this, getting an error message , like: - Error loading file , Line 0 , source =" - Reason = Not enough stoarge is available to complete this operation. My enviro...

Hi, I am having a 300 lines of SQL(Oracle), which is joining 36 tables altogether in the same SQL. Ex: Select c1.a, c2.b from c1,c2 where c1.a in ( select b1.a from b1,b2 where b1.a in ( select a1.a from a1,a2 where a1.a in ( ....... ) ) ) , like that , It is something like inline views in oracle ki...

Hi, I am having an issue with the compiler options (Datastage 8.0 / Build 1.2 ) are shown as below. My questions are: 1) Are these variables are going to be distinct with each installation? 2) I am just trying to add a new variable in job using Txfm / Modify , but not allowing to do, since throwing ...

u can enable APT_PM_MONITOR to true , set this to T, it wil show perf stats

Yes, it supports all analytical functions of Teradata. No issues. Thanks.
friend.kak@gmail.com

Does TPT connector stage supports teradata analytical functions like TOP / OVER when we use TPT connector at source level?
SELECT TOP 1

Thanks,
friend.kak@gmail.com

May I suggest that creation of rule sets is not something that can be learned from the manual? You really do need to have hands-on access to the software. And, if you have the software, you have the ... Very true. Reading the PAL Reference alone will not help a great deal: it's not exactly the clea...

Even though the target table is multiset the work table from which the data is select inserted into the target table is set table(This is a bug in stage). So my guess is that rest of the data is being dropped due to duplicate rows. Post the stats from the log file against this stage. it gives you t...

Please let me know whether is there any limit on the no of records that can be loaded when the target stage is Teradata Enterprise stage and with the option Progress Interval : 1000000. This is the default value. My source is having 60Lakh (6 Million) rows and job is finishing with 10L rows loaded a...

Hi, I designed a job and getting failed with this error message. Fatal : Teradata_Connector_115: [IIS-CONN-DAAPI-000034] An internal error has occurred (CC_DBSchemaRules::checkSizeDecimalSource, file CC_DBSchemaRules.cpp, line 1942) Additional Information ------------------------ 1> Design is someth...

Hi, Able to resolove the warning message but could not able to resolve FATAL message. Teradata Connector : IIS-CONN-DAAPI-----45 - Cannnot convert to *framework type int32 *(CC_PXAccessor :: setUnscaledByte, file CC_PXAccessor.cpp line 4813) Tried in multiple ways like, by casting at the source leve...

Hi, Able to resolove the warning message but could not able to resolve FATAL message. Teradata Connector : IIS-CONN-DAAPI-----45 - Cannnot convert to *framework type int32 *(CC_PXAccessor :: setUnscaledByte, file CC_PXAccessor.cpp line 4813) Tried in multiple ways like, by casting at the source leve...

hi I am facing a serious issue when I am designing my job, using the TPT connector at source level, I am trying to push the data and I am getting warning and error messages like this. Warning: Teradata Connector : IIS-CONN-DAAPI-----67 - Schema Reconcilation detected a size msimatch for field , XXX...