ETL · Integration · Salesforce


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.       

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s