DSXchange

Hi
All
ihave a file like this
company id,price,product, startdate,enddate
1 , 10 ,a ,1/1/07 ,6/1/07
1 , 20 ,a ,4/1/07 ,6/1/07
...
....
here all products end date 6/1/07

but iwant product a enddate(3/1/07) at price rate is 10..

result:

company id,price,product, startdate,enddate
1 , 10 ,a ,1/1/07 ,3/1/07

Welcome to DSXchange, madhava1238.

If this post has topic other than 'Hi', would seem to be a better one.

I have a few questions.

1. What is your Source here? Which kind of file you came to annote?
2. What is transformation you need to do? Is it always to do that making the END_DATE is a constantwith PRICE 10.

Please help me help you.

sequential file asa input and transformer and then target also sequencial file

you are try to implement Slowly changing Dimension..........

one question can clear the implementation...............

how do you determine that company_id=1, product=a and price of 10 need to have end date 31/1/07

madhava1238 wrote:but iwant product a enddate(3/1/07) at price rate is 10..

Try to expand the transformation you wanted to accomplish.