One or more loops have been detected in your database structure.

[#1]

Hi Anybody has a good solution for this error.

The reasion that I am having this is because I am loading data from two QVDs both of them have 'OriginalParty' field name ..and that field is the one I am using to join the data on the two QVDs..

Any Idea on how I can fix that?

Thxs

[Jason_Michaelides]

You need tO concatenate the 2 qvd tables together into 1.

Fact:

Load

   1 AS FactType,

   Field1,

   Field2,

   Etc

From qvd1;

CONCATENATE (Fact)

Load

   2 AS FactType,

   Field1,

   Field2,

   Etc

From qvd2;

Hope this helps,

Jason

[#3]

This didn't work!

[Jason_Michaelides]

Please post the data schema (Ctrl+T)