DSXchange

Perfect.......gr8 thanks ernie and Chulet.

now i will change the thread to resolved :D

Had to write a post script to change it.
In the mean time you can tell me how to do it.

Ernie No there is no column(ID) like that required, all they are looking for is the Tag should have those <measure-group ID="X"> </measure-group> when defining the tag on a particular column there is only one way of doing it, how i can get it as above. right now i am getting <measure-group...

Hi Folks,

Can anyone tell me how do i define a Tag which would start and end in this way? Also it would be useful if i understand what it means

<measure-group ID="X">
</measure-group>


Thanks

Thanks ernie, chulet.

I think this thread will be considered resolved.

aah right...! got that seems to be fine now.

I am cross checking with the requirement template. there i have a tag called as <measure-group ID="X">, what does this mean? can i define an xpath for MID(key column) using the above?

Hi Ernie,

I can do that, what about the output file...i need the output in xml format only.

after tranformer i can load it into one more xml with just one column,
it will make things right?

let me know, in the mean time i will be implenting.

Eostic, This worked exactly like i wanted. thank you very much. but how do i get rid of this Tag dummy? you said below here as " You may need to then edit out the "dummy" element downstream. In most good xml designs something like that would be there anyway. "" >>>>>> how do...

Chulet the Xpath expressions are as follows. file_audit_dataCreate_date >>>> /submission/row/file_audit_data/Create_date/text() create_by >>>> /submission/row/file_audit_data/create_by/text() version >>>> /submission/row/file_audit_data/version/text() file_number >>> /submission/row/file_audit_data/...

Some data elements in my xml out file is getting repeated for all the columns, my requirement is it should appear only once in the beginning followed by all the rows from the DB source. See below 3 rows of data , the black highlighted on It should be shown only once in the beginning as this is const...

Even after reading your resply i cudnt figure out what is the error?

xpath statement ???

can you give an example?

for example
i have
col1 col2
123 abc

how to define xpath for col1 and col2?

thanks

if i am not wrong, you should expose your job as web service and pass the parameters and call the webservice from the external application.

what do you mean " install the odbc drivers on datastage server "

>>> The ODBC drivers gets installed when you do the IS 8.1 install on the server,correct?

do i have to install separate ODBC drivers.

Did you get any information on this front,
were you able to connect to DB2 as400 database using ODBC driver?

Okay Thanks