DSXchange

Start by posting in the correct forum, the FAQ Discussion forum wasn't it so moved you here. Another suggestion would be to detail your issue, simply saying the data is "not getting loaded" doesn't really help us help you at all.

So, are you having any of the issues it is warning you of - data loss, corruption, data truncation or unexpected errors? It's just a warning after all, so could always be demoted via a message handler if everything seems to be working fine.

Sounds like they don't understand that your INPUT_YEAR string contains a delimited list of values rather than a single one. Best to ask them to elaborate on and clarify their statement.

Get rid of the comma at the end.

Note that the question asked in the original post was answered by battaliou. Anything beyond that should really be in another post rather than continuing to fall down this (potentially) endless rabbit hole. This in my not so humble moderator opinion.

sandeepsreedhar wrote:Now we have to send this xml as a web service.

Do you mean to a web service?

Hmmm... I was wondering if there was a way to use a Hashed File stage to do the dynamic normalization since that's an option there for account-based hashed files. Perhaps? Or does the need to join two rule that out?

It would be helpful if you... elaborated.

Not sure why you were quoting yourself but I 'fixed' both of your posts.

Report it. (no pun intended)

There has to be more in the way of error messages, yes?

I'm a little confused... is there more than one shared container in your job? Or the same container used multiple times? You've mentioned the "first shared container", "parameters to the shared containers" and "to each container", hence the question. Can you clarify you...

Any chance it is this?

I've found the easiest way to deal with include files in XML and DataStage is to actually include them in the base xsd. Copy the main xsd to a new name and then in an editor replace each "include" statement with the contents of that xsd, then import the metadata from the combo xsd and use ...

Abyss - please use the Reply to topic button that is at the top and bottom of every page rather than Reply with quote... unless you really need to quote something, of course.

Thanks.