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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gunsva

    SQL question

    Is this possible with plain SQL ? I have the following source table definition : employee_name employee_manager_id jack Bill jack Gates jill Ellison An employee can have a max of 2 records in the source table I need the following in the target table...
  2. gunsva

    Specify default values for NULL values in target fields..

    When I am loading a target table, some fields are being explicitly set to NULL, as per the business requirements. Reporting requires that all target fields with NULL values be set to at least a single space for string fields, 0 for numeric fields. What is the easiest way to achieve this ? Thanks.
  3. gunsva

    Fexp, exports NULL as string of spaces

    I am fastexporting data from a table. One of the fields in the source table is a varchar(20) and may contain NULL. When I fexp the data, fexp replaces the NULL with 20 spaces.. How do I configure fexp to not alter the NULL ? Thanks!
  4. gunsva

    Newbie question : MDL file

    How does a .MDL file get created ? And what is a .ASC file ? I was using the Transformer to source a .ASC file to build a cube.. Does the data source have to have a .ASC extension for the Transformer to be able to source it ? To build the cube, what other files must be present besides the .ASC...
  5. gunsva

    Cube Auditing

    I am a newbie to Cognos... In the Enterprise Server guide, it is mentioned that it is possible to enable auditing for a cube. Is this auditing available only for web requests ? Has anyone used this feature and found it useful ? Thanks!
  6. gunsva

    Restoring a backup A to database B

    I have a backup of a database 'A'. Have created a new database 'B'. I need to restore the backup 'A' to database 'B'. When I try this from Enterprise Manager, I get some errors. I also need to achieve the above via a RESTORE script. Any advice is appreciated a lot !

Part and Inventory Search

Back
Top