The Case Transform is used to route one row to different outputs depending on conditions. Specifies multiple paths in a single transform (different rows are processed in different ways).The Case transform simplifies branch logic in data flows by cons...

Hi All,What are the difference between SAP BODS3.1 and SAP BODS4.2.Thanks in advance.

FirstDay_PrevMonth: add_months(last_date(sysdate()), -2) + 1LastDay_PrevMonth: last_date( add_months(sysdate(),-1))First day of the current month:add_months(last_date(sysdate()), -1) + 1Last Day of the current month : last_date(sysdate())

We can create the destination file names like CSV,TXT,XML with dynamic date names in SAP BODS.Create a job with Script > Data flowScript Code:$G_CurrentDate= sysdate();print($G_CurrentDate);$G_Filename = 'Dynamic_File_Name_'||substr(sysdate(),0,10)||...

Is_valid_date is commonly commonly used function in SAP BODS.It will validate the date field with the given format as shown below:is_valid_date("DATE", 'YYYYMMDD') <>0DATE > Date Field objectCreate a data flow as mention:Source table or file > Query_...