Click here to Skip to main content
15,945,939 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello

I wanted to write a data dictionary. The data flow is following

Data goes from data source--> Oracle Layer1--> Oracle Layer2 ... Oracle layerN -->CognosPhysical Layer--> CogLogical layer... Cog N layer.

Now I have all data schema from Cognos in XML. And All Oracle table details in Excel files.

Prob is to extract these XML and Excel files. (Either through some tool XML->CSV-> Oracle or code some utility to extract)
First idea is to extract Nodes and edges, i.e. 1-1 link between 2 colums of different layers then form data dictionary.

Thanks ...!!!


Warm Regards
Posted
Updated 27-Oct-11 4:08am
v3
Comments
Mehdi Gholam 26-Oct-11 1:27am    
Please edit your question an supply more information.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900