DSXchange

Hi,

Source=table(t1) has col1,col2
Target=table(t2) has col3,col4

normal mapping (col1=>col3) and (col2=>col4)
on lookup[meeting some conditions] the column must be swapped ie.(col1=>col4) and (col2=>col3)

how to design....eny suggestion.

Thanks in adv,
Pratik.

pratik.470 wrote:Hi,

Source=table(t1) has col1,col2
Target=table(t2) has col3,col4

normal mapping (col1=>col3) and (col2=>col4)
on lookup[meeting some conditions] the column must be swapped ie.(col1=>col4) and (col2=>col3)

how to design....eny suggestion.

Thanks in adv,
Pratik.

Can't you just put the logic in the derivation of the target.
For example, in col3's derivation ,put
if meet_condition Source.col2 else Source.col1

Hi,

One more way could be like this..

Create two output links from the transformer, one with normal mapping (col1=>col3) and (col2=>col4) and second link with on lookup[meeting some conditions] the column must be swapped ie.(col1=>col4) and (col2=>col3) Add the lookup[meeting some conditions] as the constraint of the transformer... later use Link collector.

HTH.

That's unnecessary complication. The first answer is more appropriate, simply check the lookup status and swap values in each derivation based on the result of that check.

I just presented an alternative..

Of course.

Hi,

Thanks..

Remember to mark the topic as resolved...

Remember to mark the topic as resolved...