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

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rajeshkadiri
Participant
Posts: 10
Joined: Thu Sep 27, 2007 5:15 am
Location: hyd

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

Post by rajeshkadiri »

[url]
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I don't even believe it's faster during export, but have no evidence to support that belief.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I don't believe so either and also lack any empirical evidence to back that assertion up... it's all anecdotal. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply