Difference between ignore and reject

Shaik22
Tera Expert

‎08-31-2023 03:36 AM

Hello,

 

1.In Transform map a In field map section we have drop down field called choice actions what is the difference between ignore and reject.

2..How to change the data before loading in to the table using transform map.

0 Helpfuls
  • 2,247 Views
2 REPLIES 2

Hemant Goldar
Mega Sage
Mega Sage

‎08-31-2023 03:40 AM

Hi @Shaik22 ,

1. Difference between "Ignore" and "Reject" in Transform Map:

-- Imagine you have two systems with different data, and you want to transfer information from one system to another using a Transform Map. In the Transform Map, there's a section called "In Field Map" where you can decide what to do with each piece of data.

  • Ignore: If you choose "Ignore" for a field, it means that when the data is being transferred, if there's a value for that field in the source data, it will simply be skipped and not brought into the destination system. It's like saying, "Don't pay attention to this information."

  • Reject: On the other hand, if you choose "Reject" for a field, it means that if the data in that field doesn't meet certain conditions or requirements that you've set, it won't be transferred. The system will reject this data and won't allow it to move to the destination. It's like saying, "This data isn't suitable, don't use it."

 

2. Changing Data Before Loading using Transform Map:

--Imagine you're transferring data from an old customer database to a new one using a Transform Map. The old database stores customer birthdates in the format "YYYYMMDD" (like 19900115 for January 15, 1990), but the new database expects birthdates in the format "MM/DD/YYYY" (like 01/15/1990).

In the Transform Map, you can set up a rule that says: "For the 'birthdate' field, take the source data 'YYYYMMDD', and change it to 'MM/DD/YYYY' before putting it in the new database."

So, when the data transfer happens, the Transform Map will automatically convert the birthdate from the old format to the new format, making sure it matches what the new system needs. It's like reformatting the date to fit the new database's requirements.

This way, the data lands in the new database looking just the way it should, and you've successfully adapted the information to match the new system's expectations.

 

I hope this helps!

 

Regards,

Hemant 

**Please mark the appropriate response as correct answer and helpful, This may help other community users to follow correct solution.**

Mohith Devatte
Tera Sage
Tera Sage

‎08-31-2023 03:41 AM

hello @Shaik22 ,

TO answer your first question 

 

If there's no matching entry found then based on value in "choice action" field Transform map will decide what action to perform.

Create : Create a new record and reference it to location

ignore: ignore the location entry and process other field 

reject : ignores record transformation

 

 

can you please elaborate more on the second question ?

 

Hope this helps 

Mark the answer correct if this helps you 

Thanks

0 Helpfuls