DSXchange

Yes, they may exists or may not exists; I am getting the fatal errors as below;

xmlSrcReadXmlFile,0: Caught unknown exception from runLocally().
xmlSrcReadXmlFile,0: The runLocally() of the operator failed.
xmlSrcReadXmlFile,0: Operator terminated abnormally: runLocally() did not return APT_StatusOk

The tags in red are not coming from input XML file, sometimes they come and sometimes they wont come. This is a example, not particularly a contact will not come,, some times limit tags may come may not come. How to handle the xml parsing int his situation ???? If XML file is like below; <ns7:type>L...

Hi Ernie, Where you able to Import Actuate Report in MWB? I have a requirement where in final reporting tool is Actaute and have some Stored Procedure code which creates the Report. Now my problem is how can i get that Stored Procedure in MWB with Actuate report. Store procedure is out of ETL BOX an...

IBM Connector migration tool does not support Oracle Enterprise/OCI stage conversion to Oracle Connector. Please refer link below: http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r1/index.jsp?topic=/com.ibm.swg.im.iis.conn.migtool.doc/topics/migrationcapability.html Is there any other tool/utili...

Thanks for your reply Vincent... what do you mean by 480 PVU limit?

You can buy a server-only licence, even in the latest versions. The SAP R/3 Pack was originally designed for server jobs, and continues to be supported for them. Thanks for your help Ray. I know Server jobs will not be as fast as parallel jobs, performance wise, but is there anything else that woul...

Hi All, We have a req to source data from SAP R/3 and other relational sources using Datastage and load in the DW. There is no load window constraint and volume of data is also small. With these req and the price constraint we are considering Server Jobs only. My questions, 1. Can we not BUY the Par...

here the issue, we need to retrieve the reference data based on lookup condition, for specific ID & REF_TS, we will get the some key fields data from reference table.

My Source Data: ID SOURCE_TS 230 2012-05-31 15:13:32.6540000 230 2012-05-31 15:13:52.1540000 Reference Data: REF_ID REF_TS 230 2012-03-22 07:19:37.1490000 230 2012-05-31 15:13:32.6540000 230 2012-05-31 15:13:52.1540000 Getting Error:- Ignoring duplicate entry at table record 3; no further warnings w...

Issue Resoved; There is no issue with version of datastage; Here we need to define the DSN's properly. In MS SQL Server 2008, we need to uncheck option for "Perform Translation for Character Data"; This will handle the timestamp with micro-seconds; We raised a PMR on this, still IBM is wor...

we have standard template given by client to load into the audit table.There is no problem in the template I can not change the template. My question is there is no records in the dataset.why it is showing records in the datastage designer. This is generic question, if designer is showing records, ...

Could any one help on this ? As I have around 650jobs where I need to use conversion functions to handle timestamp.

If lookup fails, I think you kept to Continue. Then if the field "JOB_BATCH_GK" is non-nullalbe, then obvisouly for the lookup failed records, "nothing" will carry to transformer stage. So.. in the after part of the Lookup... make JOB_BATCH_GK Nullable and handle in the transform...

You Specified, sequencer will take count of the links and loaded into the audit table. This means you are using Basic fuctions; Now your job is like this DataSet1 DataSet2 | | link1 link2 | | TeraDatastage ---(srclnk)--------> Lookup Stage1 --------> Lookup Stage2 -------(tgtlnk)------>TeraDataStage...

In DS8.5 version ; I am using SQL Enterprise Stage, where I defined a column as TimeStamp(29) and exntended property set to MicroSeconds. I am able to read the data from the table. Recently upgraded to DS 8.7Version; I exported the job and tried to view the data but its throwing error as below; No d...