Add the values

[ravindraa]

Hi, all we have one requirement, here we have 2 databases in that 1 database have Business field but one database doesn't have Business field i mean particular database which  is not maintain the Business field have 3 tables, each table maintain 3 types of Business ,

                            i mean 1 table maintain permanent customer(code :: PRC),

                            2 table maintain only10 years customer(code::HRC),

                            3 table maintains only 5 years customer(code::SRC)

once i load these 3  table i got all values but i need to maintain these codes along with those value under Business field

EX;

tables1

customer   contract     status

Nag             101          Active

gopal          102          cancelled

krishna        104          active

like this my DB data existed but i need to maintain DATA like below

customer   contract      status             Business

Nag             101          Active              PRC

gopal          102          cancelled          HRC

krishna        104          active               SRC

if any one know please give me suggestion .

[sushil353 · Accepted solution]

Hi,

While loading the data from database create a field "Business" for every table..

Table1:

Load 'PRC' as Business,

..

..

From source;

Table2:

Load 'HRC' as Business,

..

..

From source.

Table3:

Load 'SRC' as Business,

..

..

From Source;

HTH

Sushil

[ravindraa]

Hi Sushil Kumar,

   Thanks for you suggestion for  my requirement it is working.