Scenario

dudam · Post by **dudam** » Fri Mar 09, 2012 3:00 am

Hi to all

I have a one scenario like..

Source Target
C1 C2 first run
A 10 A 10 1 1
B 20 B 20 2 1
C 30 C 30 3 1

Second Run
A 10 1 2
B 20 2 2
C 30 3 2

Third Run

A 10 1 3
B 20 2 3
C 30 3 3

How we can solve ...plz help me

Thanks in Advance

kandyshandy · Post by **kandyshandy** » Fri Mar 09, 2012 3:13 am

Why on friday?

Explain us what you are trying to achieve in english.

qt_ky · Post by **qt_ky** » Fri Mar 09, 2012 8:00 am

kandyshandy wrote:Why on friday?

Are you wearing your Hawaiian shirt today?

qt_ky · Post by **qt_ky** » Fri Mar 09, 2012 8:04 am

dudam wrote:How we can solve ...plz help me

Add a column with Transformer stage derivation of system variable @INROWNUM.

Add +1 to the final column value, assuming an initial value of zero.

Problem solved!

kandyshandy · Post by **kandyshandy** » Sun Mar 11, 2012 8:42 pm

What about second & third run's output?

qt_ky · Post by **qt_ky** » Sun Mar 11, 2012 8:53 pm

1st-3rd run output looks the same except last column increments. Try it and see...

DSXchange

Scenario

Scenario

Re: Scnario