Values move from staging table to local table

[Sengeni]

Hi,

I have created a staging table called "Account enable status staging" and main /local table"account enable staus".For inserting values i have use bulk upload. The Values are inserting to the staging table.

Now i want is using transform map the values in the staging table are move to local table without any values are repeating.Please help me with the tranform map as soon as possible.

[Ankur Bawiskar]

Hi,

you need to design the transform map based on your tables and accordingly create the field maps

you need to decide which field would be coalesce=true in field map

if match is found against that field it would update; else it would insert

regards
Ankur

[Sengeni]

Hi, 

i have created field maps

For moving values from stagging to main table,we have to do some logic.please help me with that 

[Ankur Bawiskar · Accepted solution]

Hi,

once data is inserted into staging table it would automatically run the transform map and process it

regards
Ankur

[Sengeni]

Hi,

Thankyou for your answer,it is working fine.I have another doubt.if more than one records repeating in table, how to restrict that,we have to write script for that? where we have to write in main table or stagging table or in transform map.Please help me with that