Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data coming from 2 source tables where i need to combine both into one table.. tried using outer join .. but data is not getting loaded.. pls. see below and any insight to resolve this would help
Bridge:
Load
CLIENT,
Number,
Type,
Record_Type,
Program
UPDATE_DATE,
Service,
Rate
Resident CRMService
;
outer join Bridge:
Load
CLIENT,
claimId,
CurrentStatus,
Entry_Id,
Source_Name,
ServiceType,
Method,
[Resolved Date],
[Add Date],
Status,
Service,
Rate
Resident ClaimServices
Also tried using Concatenate , but no table found error showing up
Bridge:
Load
CLIENT,
Number,
Type,
Record_Type,
Program
UPDATE_DATE,
Service,
Rate
Resident CRMService
;
Concatenate (Bridge)
Load
CLIENT,
claimId,
CurrentStatus,
Entry_Id,
Source_Name,
ServiceType,
Method,
[Resolved Date],
[Add Date],
Status,
Service,
Rate
Resident ClaimServices
Without knowing anything about your data I would.advice you to try these adjustments.
Bridge:
NoConcatenate Load
CLIENT,
Number,
Type,
Record_Type,
Program
UPDATE_DATE,
Service,
Rate
Resident CRMService
;
Join (Bridge)
Load
CLIENT,
claimId,
CurrentStatus,
Entry_Id,
Source_Name,
ServiceType,
Method,
[Resolved Date],
[Add Date],
Status,
Service,
Rate
Resident ClaimServices;
Bridge:
NoConcatenate Load
CLIENT,
Number,
Type,
Record_Type,
Program
UPDATE_DATE,
Service,
Rate
Resident CRMService
;
Concatenate (Bridge)
Load
CLIENT,
claimId,
CurrentStatus,
Entry_Id,
Source_Name,
ServiceType,
Method,
[Resolved Date],
[Add Date],
Status,
Service,
Rate
Resident ClaimServices;
Can you share sample input for both the tables