Reply to post: I've never seen a dummy proof solution for this

Extract, transform, load? More like extremely tough to load, amirite?

Giovani Tapini

I've never seen a dummy proof solution for this

the devil is always in the way data is mapped, which a tool can do, but only if you have the rules to apply.

Even internally in my organisation I have found that some data is very, very difficult to parse, and sometimes loses fidelity if the parsing is reversed later.

Tools or not, knowing the data is key, all you do is make the solution less code intensive.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

SUBSCRIBE TO OUR WEEKLY TECH NEWSLETTER

Biting the hand that feeds IT © 1998–2020