DSXchange

Hi, We are trying to import the metadata of cognos reports to the metadata repository of the information server using a bridge. But everytime, we get and error that looks like: ERROR MBI_COGNR_E0023: The query to cognos faild. Verify content path syntax and access rights. We are not entirely sure wh...

Hi,

We have a few cognos reports available in the XML format. How do I import these reports to the repository to make the metadata of these BI reports available to MWB?

Thanks

Also, I doubt the bug mentioned in the other thread has anything to do with the import process. The bug, i believe, has more to do with the error logs displayed that are quiet misleading. I changed the source search path field to a different value and tried directing it to a specific BI report and a...

Looks like my dispatcher URL was wrong . But now I'm getting an error similar to the one mentioned in the link in my earlier post. I think I've run into the bug

Thanks Ray. The logs for the aborted import are below INFO MIMB_I0064 : MIMB process ID=3980 INFO MIMB_I0032 : System Hardware: AMD Phenom(tm) II X2 560 Processor at 3315 MHz with 2047 MB RAM INFO MIMB_I0033 : System Software: Microsoft Windows XP 5.1 x86 with Office: 14.0 INFO MIMB_I0058 : System e...

I am trying to import BI reports via bridges into the repository. the version number of the Cognos server is requested by the bridge. However, this field is a drop-down and contains just 3 values - 8.4,8.3 and some reportnet. Our Cognos version is 10.1.1. I'm not too sure but looks like this mismatc...

Has anyone got a solution to this?

If you have nothing to do in the ELSE clause, you can code your logic like this. You will always have to tell Datastage 'if not then what'

1. Have a look at the fatal error that triggered the abort. 2. If the fatal error does not give a definite actionable error message/code, I'm sure there will be other warnings unless the job aborted due to a terminate command. 3. If the fatal error produces a database specific error, then use the co...

You need to be more elaborate.

Oops! Just realized I posted this in the wrong forum . Can the admin please move it to the right forum?

Ssreeni, I know what the SQL distinct does and how the remove duplicate stage functions. My question is which method would be me more efficient for a data volume of 60 million + records. I am not bothered about which record to retain since the records are pure duplicates i.e. every field in the dupl...

Hi, We have a table that currently has about 60 million records and will keep growing. This table contains a lot of duplicates. To extract only the unique records from a table of such a large volume, will it be efficient to use the remove duplicates stage or should I fire a DISTINCT in the SQL query...

Hi, We are loading about 40 million records into a DB2 table using DataStage. If the load fails midway, we would like to rollback whatever changes were loaded in that session. The load is incremental in nature. The only way I can think of is to set the transaction size to 0. But I'm not sure if this...

orchadmin rm "*.ds" should work