cancel
Showing results for 
Search instead for 
Did you mean: 

Import large data files into Fact Table

sairam_kondaraj2
Explorer
0 Kudos

Hi,

I need to import 60MB file into my Application. I tried import into Fact Table as Import didn't work. Even with that I am getting the Overflow error. I tried splitting the file into 2 and later into 4. Let me know of any other suggestions as I dont want to split my file into 10 files..

Thanks

Raj

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi,

You can increase the COMMITTIMEOUT in "Set AppSet parameter" some higher number. By default its set to 9000 secs. If the inset is more than this then it fails. Its just a parameter to increase the perfomance.

Hope it helps

Raman

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Raj,

If this is a one time activity, then you can try to load the file directly into the fact file in SQL using the import functionality of SQL.

Hope this helps.

sairam_kondaraj2
Explorer
0 Kudos

Thank you Radharaman and Nilanajan. It's working fine when I run the Import into Fact table with No for "run default Logic" and "run process cube". Do you have any idea on why it's behaving like this?