Transform map Workday

[Ashutosh4]

hello All, 

I am doing workday Integration and pulling the data into HR profile staging table and it is coming correctly,

then I have an OOTB transfrom map from HR profile staging to HR profile table.

But when the data loads in the staging table , it doenst have the target record or target table and it gets into Pending state. 

What is causing the issue ? 

Bit urgent, can any one please help ?

[Ashutosh4]

Also one more thing, this works perfectly fine in dev instance, but in test i have been seeing this issue, once in a while it does take the target record too, but no consistency