Hi All,We are working on IBM data stage to SAP DS migration.We got a special character issue when loading from SAP DS.our source is Oracle DB and in the data store we set codepage to UTF-8 and target is SAP BW and codepage is UTF-8Below is the specia...
Hi Experts,We are loading data from oracle source to BW target using DS.Job is running successfully in DS and also data is loaded in BW PSA. But the request status is red and the error is "Error in the data request" and error text is "Critical error,...
Hi All,We are extracting data from SAP tables and loading into flat file.The spaces between the strings are being truncated.Say we have source data like this <Ravi Kiran> and it is being loading as <RaviKiran>But it is loading correctly when the tar...
Hi all,We have a scenario to remove extra spaces between words.i have used below function and it is removing spaces completely and merging the words.replace_substr(replace_substr(Input.Column_name, ' ',''),'/t','') Can anyone provide me the correct s...
Dear experts,Can anyone help me with the below questions on bulk loading1. What is bulk loading?2. What it does?3. How to use bulk loading and when to use?4. Can i use bulk loading when we have table comparison in a DF?Thanks,Ravi kiran.
if you want to delete records in the target that are flagged "D" in the source, you could use map_operation to delete those records in the target table. take a query transform after source and apply where condition where column='D' and in map_operati...
Hello balanaveen.chilla ,Event based triggering is not possible in BODS. if you are using any third party shceduler tool, you can implement the same file watcher and event based job triggering based upon file availability and moving the files in sch...
Hello adewouters Join DIM_CALENDER table where you have Calender data like DATE, YEAR, Month etc.Below is the test table i have create with sample input data.Below is the query i have written to get the output.SELECT distinct B.YEAR_YYYY,A.AMOUNT/((...
