Hi
In my job I am using Joining stage (Outer Join) for joining two sources. For joining I imported mete data from two tables and then edited some of the output column name in Joining stage but job is running fine even thought I am getting following warning
[code]JOIN_stage : When checking operator: Dropping component "transaction_Date" because of prior component with same name [/code]
Please give some solution
Join stage warning
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Tue Jul 13, 2004 5:26 am
- Location: chennai
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Is there any chance that you have "transaction_id" being selected from both tables? This would cause some confusion for DataStage as it prefers unique column names. As mandyli has recommended change the name of your "transaction_id" columns to give them a different name within DataStage or remove one of them from the query.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 25
- Joined: Thu Oct 02, 2003 8:57 am
Hi
You will get this warning message when you have columns in the join tables which have the same name but which are NOT key columns.
The values from only one of these columns can be carried forward when the column names are the same, and these will be from the first link (as defined in the link-ordering tab).
If you need the data from both columns then you must rename one of them. If you don't need both columns then you could drop it from one of the tables, or rename the column and not propagate it.
Hope this helps
You will get this warning message when you have columns in the join tables which have the same name but which are NOT key columns.
The values from only one of these columns can be carried forward when the column names are the same, and these will be from the first link (as defined in the link-ordering tab).
If you need the data from both columns then you must rename one of them. If you don't need both columns then you could drop it from one of the tables, or rename the column and not propagate it.
Hope this helps