DSXchange

Env: Datastage v11.3.1.1 (windows) Teradata 13.0 utilites installed on engine box. while testing Bulk load, we are getting error. Teradata_Connector_0,0: Memory allocation failed (CC_TeraAdapter::setConnection, file CC_TeraAdapter.cpp, line 3,852) Teradata_Connector_0,0: The runLocally() of the oper...

Adding to chulett, Yes, you can directly migrate to V11.3.
We moved from V8.7 to V11.3 recently, no major issues, just created packages using istool and deployed and recompiled on new box. But when you use istool -incdep option, certain user defined server routines will not catch up.

Thanks Ernie. Issue Resolved. Xalan parsing errors reported by input XML stage is caused by incorrect formatting or content in source XML. These are usually fatal errors which will cause the job processing that XML file to terminate. However, in Information Server prior releases, certain fatal xalan...

From past 3yrs, our environment is on v8.7 ( DEV, QA, PROD). We started upgrade process to 11.3. We are facing issues with parallel jobs which interacts with xml's. Source of XML's is DB2 table. Getting errors Fatal Error: Fatal: XML input document parsing failed. Reason: Xalan fatal error (publicId...

How to get rid of the warning message. ? "XML input document value is empty or NULL" This is not causing job failure, just a warning message. but we need to maintain 0 errors in any job in our environment. most of the xmls coming from source are files, matching to 1 of the below struture. ...

ok. its Db2 database.

Hi Craig,

In Basic routines


Thanks

Hi All,

Is there any way to create a generic routine where if we pass a table name (and its required parameters to connect to db), it should return the table record count.


Thanks in advance

Can you please provide some stats around load time. Generally how much time will it take to load 1 TB of data with average hardware.

Thanks in advance.

Guys, I am looking to move data from one database(sybase) to another(Oracle 12c) using datastage 8.5 version. I have couple of below questions: 1) Does datastage 8.5 support Oracle 12c ? 2) What could be the best possible migration approach. I am looking to develop a RCP enabled job to migrate the d...

Hi ArndW, Thanks for reply. But the length is not fixed for all the columns and also it vary colum by column. What I am trying to say here is if the length is 12 and we got a value of 1234 then target shouldbe 200000001234.

For other columns field_size may differ.

Thanks

Hi All, I have source fields column name, data_type, Field_size respectively. Suppose if actual value of column=155 Data_type of column=NUMBER Field_Size of column=40 then I need to load the column value into target as 2000000000000000000000000000000000000155. So please let me know how to get this. ...

Hi Team, I am working on one of the job and it loads the data from orcle to the teradata tables. I am able to extraact the data from the source properly but while loading the data into the teradata target tables i am facing this error. Please help me on this issue and let me know what exactly causin...

Thanks Roland,

I am not sure whether i understood the below logic. Can you pls tell me what Table n...3,2,1 etc is ?

Also, can you pls shed some light on how we can do it using Datastage self joins ?

Thanks
Synsog

Hi Ray - Yes that s correct. In the Table, record with P1 is combined to P2 (making P2 the latest value corresponding to P1 value). A few days later, P2 might get combined to P3 (making P3 the latest) & P3 to P4. I am trying to find what is the latest 'P' value P1 is currently holding. ie P1=P2 ...