Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is aql?, how do you restrict unecessary associations ?
Could you give the context for 'aql'?
http://en.wikipedia.org/wiki/AQL
or something different I might be ignorant for.
You can restrict unnecessary associations in your data model (assuming that's what you're talking about) by renaming fields. Only fields in different tables with same field name will be associated.
Use AS to rename fields in your load:
T1:
LOAD
Customer,
Country as CustomerCountry, //breaking association here
...
FROM ...;
T2:
LOAD
Vendor,
Country as VendorCountry,
...
FROM ...;
When are you going to start doing your own homework? You may be able to collect the answers to your exam here, but you will not have learned anything.