Hi, Any one pls tell me SSIS Analysis processing Task Processing option types 1.Process Full 2.Process Update 3.Process Data Can any one pls tell me what is the difference between the above 3 types.

check this.... Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Hi, Thanks for your quick response. Pls tell me about Process data in breifly

Process data: it will process following SSAS objects Dimension, cube, measure group, partition and it will Loads the object with data without building indexes and aggregations. MSDN says Process Data Processes data only without building aggregations or indexes. If there is data is in the partitions, it will be dropped before re-populating the partition with source data. This processing option is supported for dimensions, cubes, measure groups, and partitions. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

what data in the datamart available it will load into cube rite?? pls tell me..

It will process the data you defined in Dimension, Cube, Measuer groups

My requirement is loading data into cube from datamart. When i use Process data option, Whether it will load the most recent data available in the data mart rite??

No, it will load all data into Cubes etc. If you want to process only last data, you have to process increment. But for this you have correct define the data to load. It will not validate, if some data already load into the cube. If the definition ist not correct, you have data double in the cupe.

Hi, Can i use Process data option in SSIS Analysis services task for sheduling SSAS cubes. Now im using Process Full option, It is taking 1 hour for processing 44 lakhs records. If i use the Process data option whether it will reduce process timings.. If i use Process data instead of Process full any disadvantages there?? Please guide me.. Thanks, Abdul2010

Did you already read the BOL? If you use Process Data, it might reduce the processing time, but all indices etc. will not procesed. The may have effects on query time. I don't know, how many 44 lakhs records are, but one hour is nit to much time for full processing. The processing time depends on the complexity of the SSAS database.

Hi christa, Please tell me how to reduce the processing time..

You may get faster assistance at the following forum: SQL Server Analysis ServicesKalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM