Sqoop targets are valid in mappings in a Hadoop environment if you use the Hive engine.
You can include a JDBC-compliant database as a Sqoop target in an Informatica mapping that runs in a Hadoop environment:
For example, you can include the following targets in a Sqoop mapping:
Aurora
Greenplum
IBM DB2
IBM DB2 for z/OS
Microsoft SQL Server
Netezza
Oracle
Teradata
You can insert data. You cannot update or delete data in a target. If you configure update arguments, the Sqoop program ignores them.
If you create a password file to access a database, to run the mapping successfully, you must ensure that the password file exists on HDFS. If a column name contains a special character, the Sqoop export process fails.