Page 1 of 1

diff b/t .dsx and .xml in datastage manager

Posted: Wed Apr 09, 2008 11:52 pm
by rajeshkadiri
[url]

Posted: Thu Apr 10, 2008 3:31 pm
by ray.wurlod
Both formats contain exactly the same information. DSX is the more compact format, as it does not contain XML tags. Therefore I prefer DSX, as it creates a smaller file to store/email.

Posted: Thu Apr 10, 2008 3:37 pm
by chulett
Be aware that xml is not faster when it comes to importing it as it must first be converted to dsx format and then imported. And that's not a speedy conversion.

Posted: Thu Apr 10, 2008 3:51 pm
by ray.wurlod
I don't even believe it's faster during export, but have no evidence to support that belief.

Posted: Thu Apr 10, 2008 4:59 pm
by chulett
I don't believe so either and also lack any empirical evidence to back that assertion up... it's all anecdotal. :wink: