DSXchange

Just to be clear below is an example The input is Field1 ABC, DEF, GHI, JKL Field2 123, 456, 789, 523 The output required is Field1 ABC, DEF, GHI, JKL Field2 789, 123, 523, 456 Nothing but each person for field1 should have anothers persons number but not his number , this should happen for all of t...

There is a field which has 4 digits coming from the source. In a transformer I was trying to compare the first record and next record that can be any record.Once I compare if they are different I should exchange their number. I used stage variable and stored the record as prev and then appended anot...

Yes I gave [0,20] and that worked. One last question is the nullable in PER_ID:nullable string[max=20]=substring[0,20](PER_ID) to change the nullability,as I need to change the nullability to not null for the same field along with decreasing the length. So do I need to give something like PER_ID:not...

Used the dame function PER_ID:nullable string[max=20]=substring[1,20](PER_ID) but still gives me warning modify: When checking operator: When binding output schema variable "outRec": When binding output interface field "PER_ID" to field "PER_ID": Conversion from source ...

so should the specification be
PER_ID:nullable uString[1,20](substring)=PER_ID

please suggest

Also when I tried to decrease the length from 50 to 20 using the same function it gives a warning modify: When checking operator: When binding output schema variable "outRec": When binding output interface field "PER_ID" to field "PER_ID": Implicit conversion from sourc...

Just wanted to be clear Specification=newfieldname:nullable[max=255]=oldfieldname This one is to change the nullability and length. Specification=newfieldname:Notnullable varchar[max=255]=oldfieldname This one is to change the nullability to No and also change the datatype and length. So do I need t...

I need to change the length of a field in modify stage from varchar 50 to varchar 255.

Please suggest me the function to change the length of the field to be given at the specification.

I looked at the parallel job guide but cannot find it.

Thanks

Thanks Ray.


please specify where do I use that function?

do we have any environmental parameter?

I have fields in the source A, B, C which has lengths 1,5,20. I gave a definedstring value in the environmental parameters for null values given as destr1,destr7 which gives values 'U' for destr1 and 'UNKNOWN' for destr7. I used these definedstring values as NVL in the source query which gives me wa...

Yes resolved!!

Yes now I hash partitioned and sorted the date field along with the person number.
Time field only sort but all fields ascending. and retain the last in remove duplicates.

Thanks for your detailed explanation.

After the source in the transformer stage I split the timestamp into two fields date and time. After transformer I used remove duplicates stage, In that stage I hash partitioned and sorted personnumber ascending order. And the rest date and time fields only sorting and ascending order. In the same s...

I can do the same as you said for getting the max date for each personnumber but my requirement was to get max time for each day and the result should have all the dates which the personnumber has but should be only max time of each day. and eliminated the other times of that particular date. hope y...

converting to Julian to transformer is using the function julianday fromdate. and I have timestamp, so do I need to change it to date and then julian. how do I do the max julian date in the transformer? Also, can I truncate the timestamp field and make it a new field after that I will sort the newfi...