I have recently imported the .ATL files to crate jobs in SAP Data Services as part of our Migration Project on HCM.
After loading the jobs, I have also imported the .atl files which has created some Data Stores in my SAP DS Tool.
Source – SQL Target – SAP ECC
We have received a test mapping excel sheet from our functional consultant with few Data Sheets in it like Sheet1 on Pa0000 and on Sheet 2 Pa0001…like wise, we have last sheet named as Lookup and Lookup reference.
Is it like normally, we need to create a file format and load the data or is there any other way.
And do i need create tables in DS and put this data into that tables.
Could any look into this and guide me on this.
Thanking you in Advance