I had a view called "Event" with let's say 6 columns in Informatica IDS. Later I added 2 new columns in it and asked Admin to promote the code. Code promotion is successful but i could not see changes reflected .
I have created ODBC connection in TOAD-Analytics and querying this table. Can someone tell me how it happens? Am i missing anything here.
P.S.: I'm new to IDS and started working recently, so may be for someone it is dumb question