optimize multiple concatenate

[federicacci]

Hi all,

I need to optimize a multiple concatenate.

The situation is the following:
Table 1: result of concatenation of 3 identical files with 13 fields.
I want to concatenate to Table 1, other 3 identical files that have 12 fields each, mostly different from those in the Table 1.

I tried to concatenate the first 3 identical files, then the other 3 files with each other, and finally the two tables together, but I had to do a re-reading!
You have a better solution?

Thanks

[sunny_talwar]

Are you talking about a optimized qvd load here?

[federicacci]

Yes, my qvds are very big, and I would like to optimize the concatenation so quickly conclude loading.

[sunny_talwar]

Have you looked at this this thread?

Turning Unoptimized Loads into Optimized Loads