Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
How to identified which method is best to remove synthetic key, concatenate or link table??
Thanks and Regards,
Villyee Anderson.
Depends on your database....
Provide some sample data for your database... Mostly developers using Concatenate most...
Villyee,
Follow this:
Hi,
If the synthetic key is happening because two or more fields are named alike in two or more tables, the most sensible way of making sure that you are loading the data as you want is to delete those fields repeated (for example, date in header and line, and you only need one). Another option if you are developing and not sure how to associate tables is renaming fields using AS in the script:
LOAD Field AS Field.1
FROM ...
Once you are sure about how you want to associate your model, then you can decide to JOIN, CONCATENATE, KEEP, etc.
Miguel
Hi Manish,
This is interview point of question
-- Thanks
Villyee