Can we update the target without update strategy in informatica ?
-
With pmcmd command we can update
-
No
-
Yes
-
If so we need to write coding or use unix box
Yes, Informatica allows updating targets without the Update Strategy transformation. You can configure session properties to treat source rows as Update (Insert, Delete, or Update), or use pre-SQL/post-SQL in the target. Option A is incorrect because pmcmd is a command-line utility for executing workflows, not for enabling updates. Option D is partially true but not the direct answer.
To answer this question, you need to understand the concept of updating the target without an update strategy in Informatica.
Option A) With pmcmd command we can update - This option is incorrect because the pmcmd command is used to run workflows or perform other administrative tasks in Informatica, but it does not provide a direct method to update the target without an update strategy.
Option B) No - This option is incorrect because it does not consider the possibility of updating the target without an update strategy.
Option C) Yes - This option is correct because it acknowledges the possibility of updating the target without an update strategy. In Informatica, you can update the target without an update strategy by using the "Update" transformation. The "Update" transformation allows you to update records in the target based on a condition, without using an explicit update strategy.
Option D) If so we need to write coding or use Unix box - This option is incorrect because while it is possible to write custom code or use Unix commands to update the target without an update strategy, it is not the only way. As mentioned earlier, you can achieve this using the "Update" transformation in Informatica.
The correct answer is C) Yes. This option is correct because it acknowledges that it is possible to update the target without an update strategy in Informatica.