DSXchange

madhava1238 · Post by **madhava1238** » Fri May 16, 2008 3:56 am

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

ag_ram · Post by **ag_ram** » Fri May 16, 2008 4:05 am

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.

madhava1238 · Post by **madhava1238** » Fri May 16, 2008 4:10 am

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

sachin1 · Post by **sachin1** » Fri May 16, 2008 4:21 am

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

ag_ram · Post by **ag_ram** » Fri May 16, 2008 6:21 am

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

Try to expand the transformation you wanted to accomplish.