Please check your requirement.
You need relation between 2 sources to load into one Target table
Please use below mapping to achieve it.
in each expression create an ouput port and give any value... give the similar value in both EXP. In joiner give this port and join condition with normal join.
This is how you can achieve this scenario.
then how you know from source what name belongs to wht adress with out relation..
It throwing an error message..
Updated sequence generator current value from the repository for transformation SEQTRANS.
Validating transformations of mapping m_timp_kamakura_to_trating_cp...
Joiner Transformation JNRTRANS has empty condition. Transformation is not valid.
...there are invalid transformations.
Validating data flow of mapping m_timp_kamakura_to_trating_cp...
...data flow validation completed with no errors.
Parsing mapping m_timp_kamakura_to_trating_cp...
...parsing completed with no errors.
******** Mapping m_timp_kamakura_to_trating_cp is INVALID ********
mapping m_timp_kamakura_to_trating_cp updated.
Looks like you did not provide the Join condition in the condition tab of joiner transformation. Please provide the join condition to overcome this error.
When you pull in two sources, that means you are starting two input pipelines. Until and unless you join them using a Joiner or Union, it is not possible to go ahead with it.
The error you are getting while you pull ports from another source in the Expression transformation because there is no relation between the two pipelines.
Think of the scenario when Source 1 has 20 rows and Source 2 has 200 rows. What will the Expression transformation do then?
And for your requirement, you can simply eliminate the Joiner and Expression if they are not being used significantly for any other purpose and you can perform the join in the Source Qualifier itself by giving it a query override.
If this post resolves your query, please mark it as the Correct Answer.
If you need more explanation on How to do then ket me know.
Let me know if the issue persists.
Syed Imad Husain.
Thanks a lot Syed,,
Any time Sathish.