I have a static data originates from oracle database. Desire structure will be following ways
i know sql query using sysdate so it will be take care @time of live environment n talend also . but previous 2 years static data ,i want to load day wise calculation with help of talend component or query .it must be look like Above image structure .
. I am not sure how to do this calculation day wise using talend component .please help out for problem
What does your wise calculation look like? Could you please elaborate your case with an example with input and expected output values?
HEY, I have oracle dump which have 2 years data. i want to do calculation on day level .so how we can do it dynamically in talend .
Kpi id Kpi Desc Date last week volume current week
1 B2B 2/1/2016 100 50
2 C2C 3/1/2016 500 200
can you tell me any possibility?
formula used for last week formula :TRUNC(SYSDATE) - INTERVAL '13' DAY
current week formula :TRUNC(SYSDATE) - INTERVAL '7' DAY
but unable to load static two year data ..