Welcome to my blog

I have been working with Salesforce for quite a while, so don’t hesitate to contact me if you have any questions or want some advice.

s f

Subscribe
Follow Us
h

UPDATE DATE FIELD IN SALESFORCE USING INFORMATICA WORKFLOW

 . ETL  . UPDATE DATE FIELD IN SALESFORCE USING INFORMATICA WORKFLOW

UPDATE DATE FIELD IN SALESFORCE USING INFORMATICA WORKFLOW

How to Update Date Field in Salesforce Using Informatica Workflow

Flat file to Salesforce date problems -Informatica Network

step 1: Close date format is “2020-10-31” in source file.

step 2: Select “string” datatype instead of “date/time”.

Step 3: Next step select the expression transformation from transformation tool and pass all fields into expression transformation.

Step 4: 1) Input “Date” is always in string format

              2)select variable port for the “v_Date” field, write below given expression

                TO_DATE ([field name],’YYYY-MM-DD’). In this field we need to change the data type of the date, “string” to “date/time”.

               3)Next create the output field for the Date, get date target connection from here.

Step 4: Finally connect the date field into salesforce date field execute the workflow finally get the date value in salesforce.

Post a Comment