OLE DB Source SQL:
Select customer_key From customer (nolock)
customer_key
-------------
10001
Lookup SQL:
Select customer_key, phone_type, phone_number
From phone (nolock) as ph Join customer (nolock) as c
On ph.customer_key = c.customer_key
customer_key phone_type phone_number
---------------------------------------------
10001 Home 1234
10001 Business 5678
10001 Mobile 918239
Destination Table DDL:
Cust_Phone_Info
---------------------------------------------------------
customer_key home_phone business_phone mobile_phone
---------------------------------------------------------
10001 1234 5678 918239
This what I am expecting. Now if I join these 2 SQL then result will be three rows and I don't want to store in that way in my destination table.
I hope this will clarify what I needed.
Thanks!
Bhushan