Can you please tell me if this is in Native or Blaze/Spark engine ?
Assuming that the target is also getting created during run time (since source columns are also fetched during run time), do let me know if the data is loaded properly and that the issue issue is only with the datatype of the column in the target Hive table.
If the above is true, it seems the issue is similar to an open CR - BDM-25482.
It might be due to the fact that Informatica platform datatype 'datetime' matches with both 'date' and 'timestamp' datatypes in Hive of which the latter seems to be preferred.
you described the issue correctly, the data is loaded with no issue and the only problem is the datatype in the hive target. It seems identical to the issue described in the CR you mentioned. A couple of questions on that:
1. is there a way to know the status of this CR?
2. is there some kind of a workaround until the CR will be implemented?
thanks in advance,
1 of 1 people found this helpful
You can check the status of any CR in below link:
That particular CR looks to be still open.
My suggestion is that you raise a support case to get more information.