- My Table capacity 20 Col and 22,00,000
I have to create a table view (cross Tab, Table View) with
104 Col, 13000 rows,
Could you please tell me can i do it??? Currently I'm not able to load the data load.
May be using The Generic Load
Aside from the fact that this would be an extremely wide and unwieldy table at 104 columns, what are you not sure about?
Are the columns based on a dimension or on expressions? If you have 104 expression, I sincerely hope you have carefully profiled the expressions to make sure they are optimized,
I have 104 coloms as week No's its my dimension...And I have 99 if else expressions for one measure which i have used in the cross tab view
Retrieving data ...