DSXchange

how bad is it to have a transformer stage with a bunch of stage variables, collector type = sort merge and execution mode = sequential. is performing sort extraneus if collector type is set to sort merge ?

Sorry, it is a silly mistake of mine... in my stage variable derivation i am concatenating a bunch of cols vs col1:col2:[u]if then else[/u]:col3:col4 i simply overlooked the fact that i need enclose if then else in parenthesis thats why the else condition is giving me wrong results.

I am trying to use if then else to derive stage variable. for Eg i have a col1 with values 'ABC', DBA', if my logic is if col1='ABC' then 'A' else 'B'. output should be 'ABC', 'A' 'DBA', 'B' but it is 'ABC', <null> 'DBA', 'B' if i reverse the logic if col1 <>'ABC' then 'B' else 'A' my result is 'ABC...

Sorry forgot to mention "if there is a way other than renaming one of the input columns"

Is there a way to propagate duplicate columns in join stage?

Thanks