decode(Tier, "Gold", "Tier 1" , "Platinum", "Tier 3", iif(Tier != "Gold" && Tier != "Platinum", "Tier 2") ) I tried with iif not working with above function  

decode(Tier, "Gold", "Tier 1" , "Platinum", "Tier 3", "Tier 2") 

A data engineer noticed that his is receiving CSV file containing order details of customers in S3 bucket. In that, one column is purchased datetime which is in "MM-DD-yyyy HH24:mm:ss" format. Which data prep function will be needed to convert this date to 'yyyy-MM-DDTHH:mm:ss.SSSSS" format: dformat...

Describe the functionality of Backfill which comes out of the box for various types of data sources Backfill determines what data is initially ingested. If backfill is enabled, all current files in the specified path will be ingested during the first scheduled ingestion. If backfill is disabled, onl...

A data engineer has setup a dataflow using AWS S3 connector pointing to a S3 bucket. Everyday a CSV file is copied to that S3 bucket. After successful execution of the dataflow for couple of days, the data engineer disabled the dataflow and then again enabled the dataflow after 5 days. What behavior...

You have ingested data using batch in a dataset. Which API you should use to get the metadata ?  Under Catalog API 

SCHEMA ID :_adobequaptrsd.schemas.7567f6029e5ee4a77faf20dea2718677d7448af37a7XXXXXXSuccessfully updated.Request:[{"op": "add","path": "/allOf/-","value": {"$ref": "https://ns.adobe.com/xdm/context/profile-personal-details"}},{"op": "add","path": "/allOf/-","value": {"$ref": "https://ns.adobe.com/xdm...

@Bitun 

https://experienceleague.adobe.com/en/docs/experience-platform/ingestion/quality/streaming-validation#:~:text=Synchronous%20validation%20is%20a%20method,used%20during%20the%20development%20process.