mulitple sources

[vikind]

I have four sources with no relationships between them
how can i join them. will a joiner work on all 4 sources or shud i use 3 joiners
to achieve this. all the sources are from the same database

Also I want to identify in a mapping that if a particular field is from source A
then i want its value to be X and if the same field is from source B then i want
its value to be Y how can i achieve this.

thanks for ur help

 

[Sridharan]

I've few questions for you...

1. If there is no relationships then how are you going to join them... If you can identify the columns which you will use for the relationship then SQ should help rather than Joiner...

2. You want to change the value of the field to X and Y if its from Source A and B respectively irrespective of what values comes thru those fields...

Sri

 

[blom0344]

Are you perhaps talking about merging data instead of joining? If the number of fields and their type are the same for each source, you can use just one of the sources as input and then write an override SQL-statement with unions......

T. Blom
Information analyst
tbl@shimano-eu.com

 

[vikind]

Well a union will not work since all my sources have different columns.

lets say i want to populate the Procedure_KEY in my target table
what i am trying to do is create two seperate mappings for the same target table such
that when the source A is one of the sources in Mapping_A and Source B is one of the sources in Mapping_B
(note:their is no source B in Mapping_A and viceversa) and then i hardcode the value of the Procedure_key and connect it to
the target in both the mappings like

Mapping_A

Procedure_key = 'PREAUTH'

Mapping_B

Procedure_key = 'POSTAUTH'

also the procedure_key does not come from one of the sources i create the port in each of the mappings
but my condition is when the Source is A its value shud be 'PREAUTH' and when source is B its value shud be
'POSTAUTH' so i thought the best way wud be to create two seperate mappings to acheive this.
is this a right approach ?

also i am using 2 joiners to join 3 disjoint sources ..it will give a cartesian product as i am creating
a dummy port in expression for each source to join the sources in a joiner i think it will really slow
down my mappings as if my source has 3 million records and it joins with another source of 4 million
it will result in 12 million records

 

[blom0344]

Not entirely sure what you are up to, but it looks to me that you can simply run 2 sessions sequentially in a batch, doing their inserts?

I am also totally puzzled where your need to join data comes in the picture. By the way, a cartesian product between 3million and 4 million is NOT 12 million, it is a whole lot more


T. Blom
Information analyst
tbl@shimano-eu.com

 

[Sridharan]

Well Blom infact even I'm puzzled about the requirement and infact raised a few questions which wasn't answered... I don't foresee Joiner here...

Sri

 

[vikind]

Blom and Sri..

i joined the tables in the repository that solved my joiner problem so i can do with one source qualifier. thanks for ur
prompt feedback..

as for the other question that
You want to change the value of the field to X and Y if its from Source A and B respectively irrespective of what values comes thru those fields...?

yes i want it exactly like that.
i created two workflows in sequence to achieve this one for each source and populated the same target in both mappings.