Fatal Error: Added field has duplicate identifier()

[vinsashi]

Hi,
I am performing Lookup.at the run time i am facing this problem
Fatal Error: Added field has duplicate identifier():PD_ID

Code: Select all

inputtablecolumns:
IP_ID
PD_ID(it contains data like AAA,BBB)

RefenceDatasetColumns:
PD_ID(it contains data like 1,2,3)
UNQ_ID_SRC_STM(it contains data like AAA,BBB)

in lookup stage 
i am mapping
   input.PD_ID---Reference.UNQ_ID_SRC_STM(this is key mapping)
IN TargetStage i have these columns
IP_ID(This comes from INPUT IP_ID)
PD_ID(this comes from refrence PD_ID)

I have disabled RCP at Project level.But still i am facing Problem
Note:
But i have to maintain Those column names as same in target ,source,and refrence

any solution with out changing columns names as above
Thanks in adavance
vin..

[chulett]

What happens if you map your target IP_ID field from the reference IP_ID field?

[vinsashi]

In the reference i have only PD_ID,UNQ_ID_SRC_STM fileds only ..So I have to map IP_ID from Source input.
Thanks
vin..

[ray.wurlod]

Note:
But i have to maintain Those column names as same in target, source, and refrence

No you don't. You can change them (to get things to work) and reinstate them downstream.

Check that RCP is not enabled in the job and in the Lookup stage, even though you state that it is disabled as a project default.