update (All Mapped Fields) Vs replace

[Former Member]

Hi All,

small clarifications.

1. how can i set default values for a field at import level

2. how can i set default for a field at data manger level

3. difference update (All Mapped Fields) Vs replace ..... I have read the import manger guide ...... both means the same to me ................... pls explain...... what is the use of each and when these options are used.

4. what is the use of filter check box in data manager against Qualified table. pls explain with example(not understood clearly in help doc)

thnx,

verma

[Former Member]

Hello verma

1. you can create "fake" field in source and fill it than map this field to your destination field value (or add value from you "fake" source field to destination)

2. You can create assignment and launch it through WF for update, for insert or for add

3. Replace - delete old record and create new with values from mapped fields, update - just update mapped fields if your record contain some not mapped fields their wil be clear = null

4. Filter set relation between your QLUT in "Search Parameters" Panel and records in your QLUT window

for example in QLUT you have records

r1

r1

r3

r2

r1

in "Search Parameters" Panel

QLUT you can select from:

r1

r2

r3

if your Filter is "On"

when you select "r1" in "Search Parameters" Panel QLUT

in QLUT window you have seen records:

r1

r1

r1

But if your Filer is "Off"

in QLUT window you have seen all records

Regards

Kanstantsin Chernichenka

[Former Member]

Hi Kanstantsin,

thanks for the quick reply.

Could you pls explain point 3 in detail

3. updating a mapped field and replacing a mapped field seems to same, then why two functionality

regards,

verma

[Former Member]

Hello verma

Replase delete old record and save new accroding to mapping rules.

Update all mapped fields - update just fields which have been mapped

if you have in source and in destination 10 fields but you want to update 3 of them

map 3 fields and use update all mapped

if you want to leave just 3 fields filled (another 7 are clear)

map 3 fields and use replace

Regards

Kanstantsin Chernichenka

[Former Member]

take an example :

if you have a product : where there is an auto id and also an internal guid being generated as u create a new record.

update : auto id/ internal guid remains as is : the mapped fields are updated with new values

replace : new auto id/ guid created : so programatically this is diff than update

hope this clear

thanks

-Adrivit

[Former Member]

Hi Kanstantsin/Adrivit

Thanks for your help .......i understood.

rgds

verma

[Former Member]

good - samajh ne ke baad thoda point bhi diya karo - gareeb nahi ho jaoge !