You need to add those new columns in the mapping and change the target to Upsert. that would be like existing data update for those new columns and new data insert.
I am looking for some dynamic solution as there can be any number of columns which can be added in source.
Is there any way that Informatica synchronise source and target and do automap from source to target.
We have this feature in DRS but for that there is a limitation that our source should be salesforce. To alter table (add new field dynamically) we have to set AutoAlterColumnType customer property in Agent configuration.
This flag will handle if there is an additional column added to the source and will add that column dynamically to the target database.
Please have a look at following KB article:
My source is sql server.
I tried this option but it doent seem to work until we parameterize the target completely.
1 of 1 people found this helpful
I think, It is not possible currently. Source need to be modified in the mapping to reflect the updated definition.
On the target however, if it is an replication task, there is an option of automatic target definition update which will drop the target and recreate with the current source table definition by making use of 'Reset Target' option.
Hi Ramta Batra,
If your looking for direct 1 to 1 mapping from source to target then you can use below method.
Specify the source connection Type as Parameter. Click on new parameter and enter details.
Do the same at target end too. (Create New parameter and select that)
In field mapping select Field map option as below. (Create New mapping parameter and select that)
When you run the mapping it will ask to select the source file , target file and source and target names gets auto matched if both are the same or we can do manual matching.
With this method we can load n no of tables using single mapping.
Thanks & Regards,
Yes, thats right but I am looking for a solution where I can provide parameter values only once and not everytime I need to run the mapping.
This approach works fine if you provide the parameter values at runtime.