TuplePreprocessor

In a Tuple Preprocessor file,how can i set a field of the database,even if it isnt an item in the respective DCR.
for eg if i have a field 'abc' in the database but my DCR doesnt have an respective item;is it possible to set 'abc' in the database through a hash object in the Tuple Preprocessor file?Does the Hash object contain only those keys as the items in the DCR?

Find more posts tagged with

Comments

Ambuj

In a Tuple Preprocessor file,how can i set a field of the database,even if it isnt an item in the respective DCR.
for eg if i have a field 'abc' in the database but my DCR doesnt have an respective item;is it possible to set 'abc' in the database through a hash object in the Tuple Preprocessor file?Does the Hash object contain only those keys as the items in the DCR?

If I understand correctly you want to know about this line in XML...

[html]

[/html]

where column name="COUNTRY" is a name (COUNTRY) of column in the database and value-from-field="COUTNRY" is the name (COUTNRY) in the DCR.

If you have something like REGION as a field in DCR and you want to store it in country then you can very well do below...

[html]

[/html]

Both names need not be same...

Let me know if your query is something else...

Cheers,
Ambuj Smiley Happy

Nikunj

Hey Thanks for the reply...
But what i was asking is...
i want to set a field in database after passing DCR thru Tuple preprocessor(i.e. making hashtable object of the DCR)...
but here thing is the value which we r goin to set in database has no mapping with the field in DCR..i.e. the dd config doesnot conatain tht mapping...

Here is our scenario:
we our passing dcr to Tuple preprocessor...to know tht a particular dcr is coming frm which folder(e.g..frm "eng" or "span" folder)...
Accordingly we will set the field("language") in database as "eng" or "span"...
Now situation is like tht..in our dcrs we dont hav an item as language so tht we can map it to database....(if it would hav thn der would hav been no need of preprocessor..right).

So pls help me....

Migrateduser

You put whatever you want to in the Hashtable even items that are not in the DCR. The point is that you get control of the hashtable that represents the tuple. You can modify it as you like and pass it back to DataDeploy.

Mariam

Nikunj

Hey thnks for ur reply..

I think a Hash table object is implicitly created when the Tuple preprocessor is called.
So how do i add extra keys in the Hash table object.
isnt it an instance of the DCR?
Could you please explain with an example , how to define a Hash table object with keys besides those in the dcr.