DSXchange

Any suggestions are welcome....!

Suggestion: don't PUSH

It's only five hours since your original post. Some people are actually asleep at this time. Or is that unacceptable to you?

If you need an urgent response, sign up with your official support provider for priority service. Even then, after handing over wads of currency, I doubt you'll get better than four hour response time.

okay....!

You should be able to help yourself on the second question by doing an exact search for nillable here. I posted the same question some time ago.

what abt the first one?

Thanks chullet and ernie, got the secong question,

still working on the first one.

Explain to us what "supress the '00' or 'ZZ'" means. If you want the elements to be empty, you need the data values to be null.

those are the default values i had put for null values,
but it seems like the question has been answered by this statement.

All parsers whether it is custom made / product based should follow W3C xml 1.0 standard. According to the standard the parser should read <empty/> and <empty> </empty> in the same way.

thanks folks, i will make this thread as resolved.

have a gr8 weekend.

Right, those two tag styles are equivalent.

after making this change in transformer,

IF ISNULL(read_ora.middle_name) OR read_ora.middle_name <= 0 THEN '<': 'middle_name':' xsi:nil="true"':'/>' ELSE read_ora.middle_name

i had some elements which were not repeating, now it seems like they are repating.

i have checked one column from where the repeating elements start, but the elements above that is also repeating.

i have also checkd agg all rows in the target stage,
did i miss something here again.

Hmm. Hard to say, but it's "possible" that this change in your transformer impacted the uniqueness of your element....and then altered the aggregation. You are probably going to need to break it down and determine first if the Derivation really caused it, and then what specifically about the derivation and it's result are creating the scenario.

Try also changing which column is indicated as the "key" in this lower level node.

Ernie

tried both ernie,

may be you want to have a look at the xpath expressions, posted here.