This content has been marked as final. Show 5 replies
If these are physically mapped then change the join inner to to Left outer or else you can go with
For logical source 'product p1' properties->General tab
Click on Add button and select ' product_group p2' and set Type as 'Left Outer'
If these tables are with complex join then double click on join mapping to get join wizard->Select table at 'Driving' and 'Type' Left outer or Right Outer.
Do these in BMM layer.
If helps pls mark
I tried all the possibilities given.
All the values are coming until I pass the dates. When I pass the dates since there is no date for record C in Table2, its not coming.
Sudha777: For which column I should keep null..? Date Column..?? I tried to keep NULL for date but it throws error. How to keep NULL for date column...??