We have a scenario in which we need to read from a Hive table, truncate the same table and reload it from the update data. Is it possible to do it in the same mapping without using an intermediate temp table/stage.
We are using Informatica DEI 10.4.0.1. What are the alternative and best way to achieve this and what considerations should we account for?
I think it is possible for non-partitioned tables with some trick.
Recreate a table with two partitions so that all data is in only one.
Next, set both checkboxes "Truncate table" and "truncate table partitions" for your target hive table .