Thanks, In the enrichment activity, i would assume i will take the primary set as "load file" ( this has got the main data to be ingested), now, i'm looking to include the output from reconciliation as an additional element before passing the enriched data set to "update' activity. However, I can only select a variable from the primary data as an additional field (so that i can use that variable in the update step). Am I looking the correct way, or the primary data (inside enrichment) should be ...

Thanks John, the instruction is very clear and it worked. Thanks a ton for your help!!

thanks John. I tried to run this and resulted in the following error in the "UPDATE" activity. The 'key' identification type chosen is not compatible with the configuration of the reconciliation keys (step '')

Thanks John. I'm yet to try this. The additional field added to the first query (orguint2) to be reconciled with orgunit table as well (inside reconcile activity)? otherwise we are assigning the text value right?

thanks for the reply John. let me clarify the requirement . Let's say Profile A is set to orgunit value="orgunit 1", i would like to update profile's org unit value to "orgunit2". Both org units are defined under admin/security/org units. I've a query to fetch profile A, going into reconcile activity with organizational dimension with ID mapping (profile orgid & orgunit id), now how do i update to org value of that profile to orgunit2?

can you elaborate how to lookup the value in the DB? we know the organization unit name but don't know the value to set.