empty tags

Nagaraj · Post by **Nagaraj** » Thu Apr 14, 2011 7:55 pm

Any suggestions are welcome....!

ray.wurlod · Post by **ray.wurlod** » Thu Apr 14, 2011 8:46 pm

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.

Nagaraj · Post by **Nagaraj** » Thu Apr 14, 2011 9:08 pm

okay....!

chulett · Post by **chulett** » Thu Apr 14, 2011 9:37 pm

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.

Nagaraj · Post by **Nagaraj** » Fri Apr 15, 2011 8:07 am

what abt the first one?

Nagaraj · Post by **Nagaraj** » Fri Apr 15, 2011 8:17 am

Thanks chullet and ernie, got the secong question,

still working on the first one.

chulett · Post by **chulett** » Fri Apr 15, 2011 9:11 am

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.

Nagaraj · Post by **Nagaraj** » Fri Apr 15, 2011 10:01 am

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.

chulett · Post by **chulett** » Fri Apr 15, 2011 10:46 am

Right, those two tag styles are equivalent.

Nagaraj · Post by **Nagaraj** » Fri Apr 15, 2011 12:23 pm

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.

eostic · Post by **eostic** » Fri Apr 15, 2011 12:40 pm

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

Nagaraj · Post by **Nagaraj** » Fri Apr 15, 2011 1:55 pm

tried both ernie,

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