column swaping

[pratik.470]

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.

[fyaqq]

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

[asitagrawal]

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.

[chulett]

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.

[asitagrawal]

I just presented an alternative..

[chulett]

Of course.

[pratik.470]

Hi,

Thanks..

[asitagrawal]

Remember to mark the topic as resolved...

[asitagrawal]

Remember to mark the topic as resolved...