hi all,
i am using a join stage and i am getting the warining as
"Join_124: When checking operator: Dropping component "MISCORR" because of a prior component with the same name."
--> MISSCORR is output column name ...
warining in JoinStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Thu Jul 27, 2006 10:05 pm
- Location: Mumbai
Re: warining in JoinStage
This warning occurs when you have columns with the same name in both the left and right datasets. Rename the column "MISCORR" in the right dataset.boppanakrishna wrote:hi all,
i am using a join stage and i am getting the warining as
"Join_124: When checking operator: Dropping component "MISCORR" because of a prior component with the same name."
--> MISSCORR is output column name ...
Re: warining in JoinStage
It seems both input and output links have column "MISCORR". If this column is not a join key, the stage only carry the left link's "MISCORR" field and will drop the right link's.
Suggest you to remove input link's unnecessary columns to avoid this kind of warning messages. You may earn performance gain if your data volume is significant.
Suggest you to remove input link's unnecessary columns to avoid this kind of warning messages. You may earn performance gain if your data volume is significant.
alphac
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Hi,
Possible solution for this is to change the column name of any one link i.e either in left or right . You can perform this operation by using copy stage or in any stage before your join link.
One more solution for this is Disable RCP at the job level. It will not throw any warning.
One more better solution is to search in this forum. You will get more posts for the same question.
Possible solution for this is to change the column name of any one link i.e either in left or right . You can perform this operation by using copy stage or in any stage before your join link.
One more solution for this is Disable RCP at the job level. It will not throw any warning.
One more better solution is to search in this forum. You will get more posts for the same question.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Participant
- Posts: 106
- Joined: Thu Jul 27, 2006 10:05 pm
- Location: Mumbai
hiNageshsunkoji wrote:Hi,
Possible solution for this is to change the column name of any one link i.e either in left or right . You can perform this operation by using copy stage or in any stage before your join link.
One more solution for this is Disable RCP at the job level. It will not throw any warning.
One more better solution is to search in this forum. You will get more posts for the same question.
Thnks for your suggestion, i have already changed the column names in the join stage ...but still it is not working ..
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
thanks for ur inputthebird wrote:Change the column name in one of the links to the Join Stage and also switch off RCP on both the links to the Join Stage. This should take care of your warning.
The Bird.
if switch off the RPC,in output data set i did not get the data in ralated columns in the join stage columns.