Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I tried SCD type 2 for scd_start and scd_End inside tOracleSCD, it works successfully for any year i.e YYYY format,(there is a radio button to add end date as NULL or Fixed year value).
The outcome of it is 01- 01-9999 by default. I wanted to make it 31-12-9999 (here I am unable to control day and month). Please assist.
I am using Talend 6.3
Thanks Shong.
I have checked the Java code inside SCD component, there EXTRACT(Year) keyword is mentioned.
If will remove that ,ideally it should work.
Can you please assist, how to open a jira issue on Talend Bugtracker
Hi
The fixed year value only support year value input, the output will be 01-01-your_year_value. You can open a jira issue on Talend Bugtracker to our R&D team to evaluate whether this field needs to be modified to support custom month.
Regards
Shong
Thanks Shong.
I have checked the Java code inside SCD component, there EXTRACT(Year) keyword is mentioned.
If will remove that ,ideally it should work.
Can you please assist, how to open a jira issue on Talend Bugtracker
I would always recommend using the fist date of the far away year instead of using the last date.
You do not need the last 12 month in the year far away of our live time.
Using the first date make things much easier - even the select of the current records only by the year.