what is an mdx file

vellanki · Post by **vellanki** » Thu May 10, 2007 8:25 am

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

chulett · Post by **chulett** » Thu May 10, 2007 8:43 am

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'.

mctny · Post by **mctny** » Thu May 10, 2007 8:45 am

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

chulett · Post by **chulett** » Thu May 10, 2007 8:49 am

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.