DSXchange

Hi,
How do i create an mdx file in datastage. Can any one please tell me what an mdx file is ? How its been generated in DataStage px 7.5. What is its importance.

Thanks

Whomever told you that you needed to do this should be the one to ask about what it is and guide you on how to do it. Sounds like some kind of Borland/dBase file:

http://filext.com/file-extension/mdx

I'm guessing what you'll actually end up doing is generating a delimited flat file (csv?) that is imported by some kind of utility on 'the other side'.

mdx is also the Microsoft's multidimensional ( cube) sql standard. I don't know if those files have mdx extension though.

Ah... I was assuming that was the extension, especially since it was written in lower case. Guess that may not be the case. Still, go back to whomever gave you the requirement for guidance. Or at least for guidance as to who in your organization can give you some guidance.