$syn

[sagaraperera]

I want to withdraw $ syn are cause it to below picture. Why are the sketch and description, claims a table number. Method to clarify concerns, and to make the table from $ syn.

sagara

[prma7799]

Hi,

Can you post some sample data?

Or you can you Qualify , unqualify operator to remove  $syn.

Thanks

PM

[PrashantSangle]

Hi,

There are various solutions to avoid Synthetic Key.

Some of them are.

1)Create Link Table

2) Create Key and Rename other fields

Read article wriiten by Henric about Data Modeling gives you brief idea.

Search it, you will found so many good solutions.

Regards

[jagan]

Hi,

You have more than one field common in P&LBudDate and P&LDATA2011-2014, that is why you are getting this Synthetic key.  To overcome this you need to Concatenate both the tables like this

Data:

LOAD

*,

'Budget' AS DataType

FROM P&LBudDate;

Concatenate(Data)

LOAD

*,

'Actual' AS DataType

FROM P&LDATA2011-2014;

Regards,

Jagan.