• kubilay
  • NEWBIE
  • 0 Points
  • Member since 2009

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

 

Hi 

 

I have a data integration question.

 

In Informatica on demand data loader, can I  define multiple sources of different kinds, ie. Salesforce and MS SQL Server as a "source" and then move the joined data from them to the "target" say salesforce?

 

What I would like to do is, to update with "upsert" a table in salesforce on regular basis. But for the initial load I need to get the external_id inserted in the "target" from the salesforce 

account id in the "source". So I can define the relationship. Salesforce defines relationships between objects as a "lookup". 

 

Many thanks for all your help.

 

Kubilay