Warning in lookup stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
parag.s.27
Participant
Posts: 221
Joined: Fri Feb 17, 2006 3:38 am
Location: India
Contact:

Warning in lookup stage

Post by parag.s.27 »

Can some one tell me why is this warning comming in the lookup stage.

Code: Select all

Lookup_123: When checking operator: Dropping component "UNDERWRITER" because of a prior component with the same name.
I tried searching in the forum, but could,nt get any link
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Search on keywords "prior component with the same name". Try disabling RCP.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Maveric
Participant
Posts: 388
Joined: Tue Mar 13, 2007 1:28 am

Post by Maveric »

In the Lookup stage the field names of the lookup keys should be the same and the other fields (in Reference and main link) should be unique. Like JoshGeorge said try disabling RCP or rename one of the fields.
It is our choices that show what we truly are, far more than our abilities - J.K.Rowling
samu
Charter Member
Charter Member
Posts: 16
Joined: Wed Aug 24, 2005 2:50 pm

Post by samu »

You will get this error when you have the same column names in the input, reference and output links. As maveric said try to rename the outputs coming from reference link differently or if you don't need any data coming from the reference links try to delete the columns that are not key columns.

Example1:

Input:

Col1 (Key)
Col2(Key)
Col3
Col4

Reference:

Col1 (Key)
Col2(Key)
Col3
Col4

Output:

Out1 (map) -------- Col1 ( from Input)
Out2 (map) -------- Col2 ( from Input)
Out3 (map) -------- Col3 ( from Input)
Out4 (map) -------- Col4( from Input)
Out5 (map) -------- Col3 ( from Reference)
Out6 (map) -------- Col4( from Reference)

Example2:

Input:

Col1 (Key)
Col2(Key)
Col3
Col4

Reference:

Col1 (Key)
Col2(Key)


Output:

Out1 (map) -------- Col1 ( from Input)
Out2 (map) -------- Col2 ( from Input)
Out3 (map) -------- Col3 ( from Input)
Out4 (map) -------- Col4( from Input)
Post Reply