Issue in transformation

[former_member581554]

Hi,

I am having strange issue in transformation. I have mapping as below:

My result should be unique based on employee and fiscal year. I have some custom logic in end routine on fiscal year and based on that it should have value.

While running DTP, it is giving me an error of duplicate data record even though the data is unique. After so much analyzing, i came to know that the code is not taking the fiscal year as key.

Please suggest.

Regards,

Niranjan

[Loed]

Hi Niranjan,

If you have a code in your end routine, make your FISCAL YEAR as CONSTANT with blank value so that your end routine will change its value..

Regards,

Loed

[Former Member]

Hi,

Maybe because you missed the fiscal year mapping?

Can found it in your screenshot.

Regards

Bill

[KodandaPani_KV]

Hi,

have you same data two times form source to PSA - if yes please delete the one request.

if it was routines please chec the routine syntax - what was the requirment.

while seeing the DSO structure form employee to fiscper as key fields.

which error you are facing plese share the screen shot to us.

-Phani.

[former_member581554]

Hi Phani,

Thanks for the prompt reply.

I have only 1 request in PSA. The transformation is between DSO to DSO and requirement is as follows:

I want to have the data from 2015 fiscal year afterwards. And if any employee is active and missing the fiscal year data then my code will copy the data from (missing fiscal year -1 year) data. For Ex.

The error screen shot is as follows:

[KodandaPani_KV]

Hi,

check the PSA data and it was the duplicated record is there.

2 nd record was the error form the DSO error details.

take the dump of PSA data check it out in excel sheet based on the unique records.

now you will find how many unqiue and duplicate records.

-Phani.

[KodandaPani_KV]

Hi,

out of 2 DSO's are you using any WDSO?

i think you are loading data form WDSO to standard DSO. - if yes.

plesae check the do not check unquie records setting in WDSO.

--Phani.