DSXchange

Posted: **Wed Jan 06, 2010 7:40 am**

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..

Posted: **Wed Jan 06, 2010 9:41 am**

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

Posted: **Wed Jan 06, 2010 10:05 pm**

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..

Posted: **Wed Jan 06, 2010 10:56 pm**

vinsashi wrote: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.

DSXchange

Fatal Error: Added field has duplicate identifier()

Fatal Error: Added field has duplicate identifier()

Re: Fatal Error: Added field has duplicate identifier()