The source of the profile_export_for_destination_merge_policy__XXX is all record based datasets which have been marked for profile.

Please refer to the following digram which outlines the latency through each component.https://experienceleague.adobe.com/en/docs/blueprints-learn/architecture/architecture-overview/deployment/guardrails#end-to-end-latency-diagrams

Hello @Indra  Are you requesting the processing time of data which was ingested into datalake and then promoted upon the profile store?

Hello @Indra  The profile_export_for_destination_merge_policy is updated on periodic basis as profile attributes are updated. The Profile_Snapshot is updated 1 x / day after the segmentation evaluation job completes.

Hello @SaurabhCh3  if you have data in dataSet A under the path of _abc.phone.number.number I would create an a query similar to the following.  Each object should be represented by a struct. insert into dataSetB select struct(              struct(              struct(          (x.number as number) ...

@SahuSa1 Can I ask why the source is producing duplicate rows of data with the latest timestamp? If the data is not changing why is the data being re-ingested?

The merge policy has an impact on the profile store.  What is the use case you are attempting to achieve with audiences of two different merge policies.

@Adobe_WanKenobi  I can see in your initial post to this thread you are attempting to limit one postal address per customer.   Typically to designate a head of household as a data attribute would be performed outside of the Adobe Experience Platform or you can use Data Distiller to create this attri...

Hello @NickMannion  The sample size of the scan depends on the overall number of entities in your Profile store. These sample sizes are represented in the following table:Entities in Profile store Sample size Less than 1 millionFull data set1 to 20 million1 millionOver 20 million5% of total source h...

A merge policy is created at the union profile level of Adobe Experience platform.  You have the ability to select from time based or dataset precedence.   There are two options for identity stitching of private graph or none.  None: When this option is selected, IDs will not be stitched together. W...