Informatica Powercenter One to Many SQ Query and Mapping Issues -

i have multiple views person_view phone_view has 1 many relationship. in following query, got toad correctly output result 1 row each person record.

i having problem getting work informatica powercenter. copied/pasted query sq sql query section.

since query takes phone_number , check against phone_type on whether of type home, business, or personal, output 3 phone number columns called home, business, , personal.

i created 3 new columns in sq ports called home, business, , personal match query output columns. when validate query, says must match 28 ports sq. when add 1 column , map exp transformation , target, still give error. counted ports , 29. if removed phone columns, works , count 28. when add 1 phone column, gives error.

i think missing step.

any appreciated.

person view 1 john m. doe

phone view

1 111-111-1111 home 1 222-222-2222 business 1 333-333-3333 work

toad result 1 john m. doe 111-111-1111 222-222-2222 333-333-3333

here query (this works in toad)

select person.person_id,         person.first_name,        person.middle_name,        person.last_name,        phone.home,        phone.business,        phone.personal,        phone_type person_view person left join (select * (select person_id, phone_type,phone_number                             phone_view)                            pivot                            (                              max(phone_number)                               phone_type  in ('home' home,'personal'        personal , 'business' business)                             )  )phone on phone.person_id = person.person_id