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

44 Views Asked by At

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)

1

There are 1 best solutions below

1
Jim Macaulay On

You can use INSTR function,

INSTR(first_name, ' ') != 0