• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Need Clarification on master data mapping details storage

#1 2012-06-27 07:29:05

Chaya
Member
Registered: 2012-05-15
Posts: 41

Need Clarification on master data mapping details storage

Hi Talend Team,

I have an use case,
where in,  I get list of locations from "XYZ" system and also other set of locations for "ABC" system.
ex:
 
XYZ system                                                                          ABC system   
Location ID    Location                                                                       Location ID    Location
101               loc1                                                                                           2000    location-5
102              loc2                                                                                         2008    some location
104                    loc3                                                                                         2067    location1
107                 loc8                                                                                         2789    location8


In my system, I create these locations with unique id specific to my system like below
My system.
ID    VALUE
1       Location1
2       Location2
3       Location3
4       Location8
5       Location5
6       some location

when i am communicating to
XYZ system... for "location 1" i need to pass the id as   "101"
ABC system .. for "location 1" i need to pass id as "2067"

so, i am also maintaining Mapping table in my DB like below,

internal_ID      external_system id      system_name
1                          101                               XYZ
1                           2067                             ABC
2                            102                               XYZ
3                              104                               XYZ
4                             107                                 XYZ
4                              2789                              ABC
.
.
.

like this, i m maintaining all the mapping details.

wel. coming to my doubts,
1. I have been told by some 1 that, Talend tool has the facility to store and manage the above mapping details,.. is that soo?
2.  is there any storage things/ components  are also available in Talend tool?


please guide me on this...

Thanks in Advance
Chaya

Offline

#2 2012-06-27 07:51:16

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Need Clarification on master data mapping details storage

Hi Chaya

Maybe what you need are the tHashOutput component and the tHashInput component which can store data in memory.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-06-27 11:21:19

Chaya
Member
Registered: 2012-05-15
Posts: 41

Re: Need Clarification on master data mapping details storage

Thanks Pedro,

Will look in to those components and see wthr that serves my purpose. Any way.. thank you..

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Need Clarification on master data mapping details storage

Board footer

Powered by FluxBB