Get the value from destination db table RRS feed

  • Question

  • Hi,

    I have a below requiremnt. Please suggest me how to do this.

    From source(Oracle), I am getting three columns data and I have to insert this data into destination table. Two columns i have mapped diectly. Upto here no issue.
    Think that my third column is country name and in the destination I have to insert the countryid instead of country name. Country master table is in destination db.How can I get the country id using the country name and how to insert this into my destination table along with other two columns.

    Ramesh D
    Tuesday, March 25, 2014 9:05 AM


All replies