ETL mapping to load employee whose first name has space in it in informatica Power Center

Question

Consider employees table as source. Create an ETL mapping to load employee whose first name has space in it. E.g First name like (Jose Manuel, John Paul)

Answer 1

You can use INSTR function,

INSTR(first_name, ' ') != 0