Recent content by MDXer

I will start a thread later today discussing the differences as I have experienced. I will do my best to get this done. I have been away from here for about 6 months for health related issues but am trying to get back and contribute.

Ties, have a star for a very well worded explination.

ROLAP MOLAP and HOLAP are simply storage modes for your data. Some products are one or the other where MS SSAS allows you to choose. Simply put MOLAP (Multidimension OLAP) Data is preaggregated and stored in a non RDMS file system. MOLAP storage tends to produce the fastest cubes when...

do the filenames following a similar pattern? If so you can read the file names based on patter matching.

That will disable the entire dataflow, but if you want to disable 1 task within a dataflow you can't.

No you can't disble transfoms in the data flow. Your best bet is to save versions of your file.

This type of work maybe easier to do on the server as part of a source query if the source is SQL Server.

without knowing the details all I can say is depends.

Utilize 2 lookups the first you will want to use full cache and the second use partial cache. The partial cache will actually query the table for the record needed and then cache the record when found so additional references to this record need not be queried.

could you paste the error message not everyone has access to online storage sites.

If your query is that large and complex have you considered breaking it into smaller queries and or pushing off some elements of the query to SSIS? I can't imagine SSIS not being able to replicate some of the functionality of your query.

If you utilize an OLE DB connection SSIS can handle any oracle query that you can execute. Store yuor query as a variable and then in your oledb connection use the variable as your query source.

The problem as I see it is you submitted requirements how detailed they were I do not know, and what you recieved was what you asked for. Even if you had said I am open to other options if companies deal with a lot of requests most people have done the research and want a price for what they ask...

it probably depends what you are trying to do.

If you have SQL 2008 it is included but you have to install it seperately. If you don't have it in one of the Microsoft SQL directories you can get it here. Microsoft Connectors for Oracle and Teradata by Attunity