DSXchange

Thank you all,for the responses.

I have developed 2 jobs, one using the Column inport and the other using the transformer stage.The run time for two of the jobs was almost the same. So I would go with either of the stages.

input stage - Sequential file output stage - Sequential file Data flow: SF-> XXX(stage to be used) -> SF This flow is used 9 times within the same job Using which stage do I map a single input column to two different output columns (other than a transformer stage to increase performance),as I have t...

Thank you for the response.I used the Field function and its working as expected.

Hello, The source is SQL server Database. Col1 - Decimal(18,2),Null ;Col2 - Decimal(18,0),Null . The target is a Sequential file. Job Design: ODBC stage--->Transformer--->Sequential file The requirement is : Source data Col1 - 400.00 ; Col2 - 20 Target expected data Col1 - 400.00 ; Col2 - 20 But whe...