DSXchange

i am updating the date column and ID in the table named X,where ID value is incremented by 1 when the job completes.but in my design oracle(X table)---->oracle(X table) its incrementing 15 times as records extracted from source is 15.this record count may vary from time to time.. IS there any work a...

try this one.
let source is source link
target is target link
lookup is lookup link
mapping is as follows.
pass source.id to target.id and key for lookup
pass source.name to target.name
pass lookup.ele.num to target.code
have i decoded the scenario correctly?

If there is any enhancements in your job in the future this copy stage(placeholder) will be useful.i think it wont improve the performance of a job

I am having a doubt in updating a table in oracle .My requirement is to update a oracle table after my first job gets over.I tried using oracle(sourcetable)---------->oracle(sametable as target) and have given update userdefined query in the target oracle stage..this is updating the table so many ti...

[quote="ray.wurlod"][color=darkred][b]Eek![/b] Not only do you hijack a thread, but you hijack a thread that's in the wrong forum in the first place! There must be some kind of award for that![/color] Meanwhile please open a new thread in the appropriate forum (server or parallel) so that ...

I am having a doubt in oracle update strategy.My requirement is to update a oracle table after my first job gets over.I tried using oracle(sourcetable)---------->oracle(sametable as target) and have given update userdefined query in the target oracle stage..this is updating the table so many times b...

i have included the null property,variable width is working fine but fixed width values is showing error.I have tried giving string pad char but its of no use. Error message: When checking operator: When validating export schema: At field "DATE_VAL": "null_field" length (1) must ...

hi,
i am pulling data with null values from oracle table(with 25 columns).I am moving it to sequential file(tat too with null option as yes) .I am getting a warning "nullable without null handling properties".Is there a way to clear the warnings.

suppose in match process u have examined a record pairs which is a matched pair ,means the field agrees this probability is called M probability. FOR EXAMPLE in a sample of 100 matched records if 20 records disagrees the match process then m probality for this variable is 0.8 (1-0.2) The u probabili...

have you set the date datatype large enough to hold the full value you want to be returned from varchar while using convert functions??

Is there a way to convert timestamp to internal format? I know about ICON/OCON functions a little bit,But I cant find this type of conversion in the document or using help in DS.

enabling checkpoints option in job properties will do good and according to my knowledge no of subsequence job wont come under performance issue,only the size of the job in a sequence comes under performance issue

use a tail stage after the transformer are at the later stage to get the highest SK value.save tat into a dataset.it be useful for saving the highest values.