Hello,

Entity Called "RawData" has 5 attributes(columns)

What I want to do is pass 3 of the five attributes(FirstName, LastName, EmployeeID) to another Entity "CleanData"

How do I do this correctly ?

Hi Siavash Noorizadeh,

Do you want to pass data between tables as a one time operation, or this operation is repeated more often?

Marco Arede wrote:

Hi Siavash Noorizadeh,

Do you want to pass data between tables as a one time operation, or this operation is repeated more often?

It will be repeated more often...


Solution

Hi Siavash Noorizadeh,

The best approach depends on the amount of records to move, and if there are identifiers with automatic numbers (namely EmployeeID).

But I'd say simply implement a batch process to mark dirty records, and another to copy clean records into the new Entity.

Does this help?

Solution

It does, 

Thank You

Good to know, thanks and good luck!