how to handle the join stage warnings
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
how to handle the join stage warnings
hi all,
i am using 4 join stages sequentially ,the join lookup is same table for 4 joins and key column also same and i am using the left outer join on 4 joins and 4 joins are produced same column as output.i got output proper but the problem is it is generating the warnings like.........
JoinNZMISSPL01: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL02: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL03: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL04: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL01: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL01: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL02: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL02: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL03: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL03: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL04: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL04: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
can u provide the input for this problem
thanks inadvance
praveen
i am using 4 join stages sequentially ,the join lookup is same table for 4 joins and key column also same and i am using the left outer join on 4 joins and 4 joins are produced same column as output.i got output proper but the problem is it is generating the warnings like.........
JoinNZMISSPL01: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL02: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL03: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL04: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL01: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL01: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL02: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL02: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL03: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL03: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL04: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL04: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
can u provide the input for this problem
thanks inadvance
praveen
Last edited by thumati.praveen on Tue Dec 05, 2006 6:16 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: join stage warnings
thumati.praveen wrote:hi all,
i am using 4 join stages sequentially ,the join lookup is same table for 4 joins and key column also same and i am using the left outer join on 4 joins and 4 joins are produced same column as output.i got output proper but the problem is it is generating the warnings like.........
JoinNZMISSPL01: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL02: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL03: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL04: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL01: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL01: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL02: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL02: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL03: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL03: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL04: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
JoinNZMISSPL04: When checking operator: Dropping component "MISCORR" because of a prior component with the same name.
can u provide the input for this problem
thanks inadvance
praveen
That is because you are having the same column name on both sides of the join. If you want to get rid of this warning, change the names.
Or else, as Ray said, Stop regarding this as a problem.
Hope this helps,
Ajith
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Hi,
Warning Messages- We have to analyse those warnings properly and by max, we have to find the cause and solution for the same.
Message Handlers are helpful, whenever your warning is not harming your job and if your unable to find a solution for your warning.
Warning like Prior Component with same is quite possible to fix. Don't go for Message Handler.
You have two options here to solve the above problem.
1) Rename the columns at the output of Join stage
2) Switch Off the RCP
Warning Messages- We have to analyse those warnings properly and by max, we have to find the cause and solution for the same.
Message Handlers are helpful, whenever your warning is not harming your job and if your unable to find a solution for your warning.
Warning like Prior Component with same is quite possible to fix. Don't go for Message Handler.
You have two options here to solve the above problem.
1) Rename the columns at the output of Join stage
2) Switch Off the RCP
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: Wed Oct 04, 2006 5:21 am
Nageshsunkoji wrote:Hi,
Warning Messages- We have to analyse those warnings properly and by max, we have to find the cause and solution for the same.
Message Handlers are helpful, whenever your warning is not harming your job and if your unable to find a solution for your warning.
Warning like Prior Component with same is quite possible to fix. Don't go for Message Handler.
You have two options here to solve the above problem.
1) Rename the columns at the output of Join stage
2) Switch Off the RCP
hi
thanks for ur input
if i switch off the RCP the data is not visible in the target and
if i rename the out columns that is also the same problem the data is not visible in the target,but in both cases the performence statistics is showing the data is moved all the records from source to target.
thanks
praveen
-
- 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
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Data is not visible means, is it showing dataset is not created in the mentioned path or it is simply showing dataser created but no data. that means empty dataset.thumati.praveen wrote:Nageshsunkoji wrote:What is your Target ?
Is it a Dataset or Database ?
Dataset
are you able to view the data without these two options ?
The path your passing at run time is it the right path ?
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Disabling RCP means that columns that formerly were automatically transferred are now not being transferred. You have to explicitly design in those transfers (mappings) if you require them to occur without RCP.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
Nageshsunkoji wrote:Data is not visible means, is it showing dataset is not created in the mentioned path or it is simply showing dataser created but no data. that means empty dataset.thumati.praveen wrote:Nageshsunkoji wrote:What is your Target ?
Is it a Dataset or Database ?
Dataset
are you able to view the data without these two options ?
The path your passing at run time is it the right path ?
i am not using the parameters.
everithig is correct
-
- 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