DSXchange

exact colum names is must. it can be any order.

Check the source query. there must be an issue. if you are passing the query as parameter. use escape character for single quotes.

Difference stage gives before dataset but not after dataset.
using which stage i can incorporate this logic? please suggest me.

The problem was i was not able to get delete records out of the change capture.im getting a null value for all th columns in the record which was designated as a delete record.

can any one suggest me that why the values are empty?

So it will be the combination of Vertical Pivot and Horizontal Pivot.
Can any one just give an outline of the design.

is any other way to do the same in Datastage?

Yes the Number of columns are Fixed That is (A1 Series) is 3 and (Value Series) is 3

I have got the solution in SQL. Here Value1,Value2,Value3 Columns Values are numbers from source Select Emp,SValues,Sum(Case when COL_NM='A1' Then Sdummy Else Null End) AS A1, Sum(Case when COL_NM='A2' Then Sdummy Else Null End) AS A2, Sum(Case when COL_NM='A3' Then Sdummy Else Null End) AS A3 FROM ...

Can anyone suggest me?

Hi experts, I have requirement below. I mean that the output table columns are dynamic i.e A1..........An EMP COL_NM value1 value2 value3 ==== ===== ==== ==== ==== 100 A1 "NAME" 100 A2 100.00 200 A1 "NAME1" 200 A3 "Y" OUTPUT TABLE ========== EMP VALUES A1 A2 A3 A4 A5 .....