DSXchange

Is there any way I can include check constraints in Schema file, to brief about this-
Say, if I am getting Data in any column as "N/A", then I have to drop that whole record and the same should not be imported from any source extract file.

Please suggest...

Verify options on UNIX, where few lists of commands will convert a CSV files into XML file, not even XSLT is required.

Base on your specifications or Requirements, it's betetr to use XSLT.
According to your requirement you don't need any XSLT usage, just try to play with csv2xml command on UNIX.

I got you.
Thank you ...

Ernie,
Thanks for sharing the information.

You were right, I am using reggular XML Table definitions approach to import. Was it wrong?

Hello All, Has anybody worked with XHTML data files. I was working with hierarchical XML before but the client has come out with XHTML stuff. i never worked on these before. So can anybody elaborate what would be the possible issues with XHTML comapred to XML. 1. I can see that the size of the XHTML...

In Server canvas, 'transaction grouping' comes into picture when the ORACLE stage(ODBC/OCI) receives multiple links from the same transformer stage. The problem with the PX job is that multiple processes are started, and there is no way for one process to rollback another process. For PX jobs you wi...

Having declaring above mentioned namespace declaration, do Load the metadata from same XML data file (or with XSD, if you have) in output link columns Tab too.

1. For Oracle Enterprise Stage, datatype in DS for the column should be 'NVarchar'.
2. For DRS stage, varchar is ok.
3. Better to keep NLS_MAP & NLS_Language as 'UTF-8 ' in both DS & Oracle respectively.

Thanks Ernie, I tried building the header with login details and the added specific hardcoded value (as it's SOAP over HTTPS) by creating the XML Response (using XML Output stage) and sending back to web service through Web Service Transformer. But didn't succeed to make it work. So It would be very...

Can anybody elaborate on including the Header and passing on them to Web Service Transformer ? Actually I have two Input parameters UserId & Password through which I will be extracting Header details like 'ServerURL' and 'SessionId'. Now My query is, How to send these two parameters as Header af...

Hello All, We are facing following error, when we execute/run through Script. Missing record delimiter " ", saw EOF instead In script we are actaully FTPing the data file & removing '^M' characters as well. But when Execute the same Datastage Job only for same Data file(after removal o...

Thanks Ray,
It's working.

Hello all, Issue was resolved with Patch what IBM has shared with us earlier, sorry for the delayed response. IBM suggests us to use the Name of the XSD file mentioned in the XML data file itself. After having done that, we just enabled the check in box "Validate" & other usual log rej...

Ok, Thanks for this detailed Info.

Patch Number Is : "patch_JR31866". It's for Sun Solaris Box.

Ernie, Thanks for the suggestion. I raised ticket with the IBM Support & they came back with a Patch.But this patch helped us to validate the XML data file against the XML Input stage Metadata only, but not with the actual (physical) XSD. I have mentioned the wrong XSD name as shown in below cod...