Cloning: Exclude Table vs. Preserve Data

[ctsmith]

Can someone go into a bit of detail on Excluding Tables and Preserving Data in a clone.  I think I had it a bit mixed up.

If you exclude a table, the documentation says: "Exclude a table to create an empty but usable table on the target instance."

So, if I exclude a table, it just creates the same table that was there with no data?  And is that the table that existed in the lower instance before the clone, now blank.  Or is it the table from PROD, blank (thinking if there are mismatches in fields between the two).

If you are preserving data on a lower instance, does that mean it keeps just that data, or does it mean it keeps that data AND adds the existing data from the PROD clone?

Let's say the scenario is this:

Table A in prod has record X.

Table A in dev has record Y.

I want Table A in dev with ONLY record Y after the clone, not Table A in dev with record X AND Y.

Let's say I want the freshest version of the table (which may be PROD) but I want the data from ONLY the lower instance that is being cloned.

Thanks!

[ajays]

To Make it more simplified ,

imagine you have 20 records in the target instance or prod instance , and 100 records in the source instance or dev instance , then by using 
"Data Preserver ": By using data preserver , you can preserve or store or make all those 20 records be contained in the target instance rather than removing them,

"Exclude Tables": for the same above example , the exclude tables will allow us to send those 20 records from all 100 records to target instance , in which it will allows us to use filter mechanisms to filter out those 20 from all 100 based on the needs 

[Suggy]

Your are confused with source and target instances. Generally source will be production 

[pawan k singh]

Validate the outcome of Preserve and Excludes to understand it better while configuring clone profile.

I will not cover the definitions, as it is already having enough in community but will try to remove the confusion here.

Please Mark this helpful, if it helps.

Regards

Pawan K Singh

[rejisnowman]

Hey Pawan,

thank you for explaining this beautifully. however preserve = Yes and Exclude = Yes would be done at Target instance right?