concatenate

[ilanbaruch]

hi all,

i have about 10 FACT tables i want to concatenate in a model.

3 of the FACT contain 10 million rows each , i load them first and it takes about 2-3 minutes each.

the other facts i'm loading contains 4-5 thousand rows each and they take about 20-30 minutes each.

is there a way to reduce the small tables load time?

of course not all the fields in the tables are in common .

advanced thanks

[evan_kurowski]

Not sure if this is possible..

[techvarun]

without knowing the field names its very hard to answer these question.

Please share some sample data to suggest a better data model

[sunny_talwar]

Few questions?

1) Are you doing a group by on the smaller tables?

2) Are you loading the data from QVD Files or anther source?