Page 1 of 1
Relation Between Datastage And XML
Posted: Tue Mar 17, 2009 11:02 pm
by sureshreddy2009
Hi my seniors told me to learn XML, i think in future i want to use XML also along with datastage, right now iam working in Datastage 8.0 parallel, may i know the relation between XML and datastage
Posted: Wed Mar 18, 2009 1:52 am
by hamzaqk
there is no relationship. i think they are on a break
Posted: Wed Mar 18, 2009 2:13 am
by ray.wurlod
XML (extensible markup language) is a way of encapsulate metadata (in the form of tags) with data. DataStage can read and write XML via specific stages (XML Input and XML output).
Good to Hear
Posted: Wed Mar 18, 2009 3:54 am
by sureshreddy2009
ray.wurlod wrote:XML (extensible markup language) is a way of encapsulate metadata (in the form of tags) with data. DataStage can read and write XML via specific stages (XML Input and XML output). ...
Your post help me in updating some knowledge, but can u please give me clarity about in any where we are using XML syntax related to datastage for client's purpose.
Posted: Wed Mar 18, 2009 7:03 am
by eostic
Hi Suresh...
XML is just a format, a "protocol" for representing data. In some ways, it is no different than a csv file that has column names on the first line. Well designed XML, as Ray notes, carries its metadata with it...metadata that represents internal structure and relationship between data elements as well as the names of individual elements. <name>Ernie</name> is a single XML "tag" that identifies the string "Ernie" as a name.
DataStage of course, is a tool for manipulating data. At the high level, XML is no different than flat files, DB2, ODBC, etc.... just another source and target.
XML has a long and colorful history. There are millions of resources on the web and in books to read about it. It started as a way to represent textual ideas, growing out of an early 90's standard called SGML. It was then adopted for data in the late 90's (some XML purists still say it was "hijacked" by the database vendors) and is becoming a farily standard protocol for transferring data in messages and transactions......
Glance at
www.w3.org and
www.w3.org/xml ...that will start you really deep, perhaps too deep, but give you an idea of the standard....from there do some searches on "XML introduction" or "XML basics" and you'll find days worth of good material to augment the threads here.
Ernie
Posted: Wed Mar 18, 2009 8:10 am
by chulett
And there are literally
tons of books out there on the subject. Go to a site like Amazon where users review the books and browse there. There's also a document we uploaded to
Kim Duke's website in his Tips section that covers XML 'Best Practices' in DataStage, well worth anyone's time to go through that.