Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compare catalog to ORacle tables

Status
Not open for further replies.
kinhell

kinhell

Technical User
Jun 15, 2006
6
GB
I need to find a way to compare my catalog to my Oracle database tables and see what new columns I need to add to my catalog. Is there any easy way other than the tables window and a side by side comparison?
 
Sort by date Sort by votes
assuming you are using Impromptu.

Open the catalogue
In menu CATALOG / Content Overview ...

Give a name.icr

Open the ICR file in notepad.
 
Upvote 0 Downvote
That still means having to check tables manually. Is there any way Impromptu can highlight what columms are missing from a catalog table?
 
Upvote 0 Downvote
'kinhell
You may find thread401-404525 of interest.

soi la, soi carré
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
212
deborahyr63
deborahyr63
nickotine
  • Locked
  • Question
Format to display Years & Months
Replies
0
Views
225
nickotine
nickotine
NileshDhande
  • Locked
  • Question
Can I use web api as data source to cognos?
Replies
0
Views
271
NileshDhande
NileshDhande
lordzul
  • Locked
  • Question
Cognos - How to use "Overall - Total" info to other calculation. Help needed :)
Replies
0
Views
213
lordzul
lordzul
dredden2
  • Locked
  • Question
COGNOS Script to modify date ranges on a Dimension
Replies
0
Views
228
dredden2
dredden2

Part and Inventory Search

Sponsor

Back
Top