DTP – DTP will load data from PSA to DSO (New Table).Activation – Data get activate & records are inserted into Active table of DSO.PSA – Persistent Staging area is temporary storage which contains copy of source data. I have mentioned copy of source data as this is 1st level storage in BI and no ETL actions are performed yet in BW for this data. PSA permits to edit every individual record before we load further. Select Edit option & edit required field.Resume data load once changes are saved.Write a field routine in transformation to exclude special or hexadecimal characters from flow Write a routine to replace special character. Compare available character with permitted character in RSKC.#loop counter will be based on length of string If STRLEN times CN ‘list of characters’ #Condition to find non permitted characters Replace non permitted/hex characters with spaceĤ.We can maintain all required characters in RSKC tcode after proper business approval. Please note – We can maintain only special character in RSKC, it is not possible to maintain hex character in RSKC as Hex character can not be entered via standard QUERTY keyboard. ![]() If you are maintaining # in RSKC that doesn’t mean you have maintained hex character value. ![]() Hex character is only interpreted as ‘#’ in PSA.ĭepends on individual to select the method to overcome special char issue in BW ETL.The English language debut of the bestselling Dutch novel, Hex, from Thomas Olde Heuvelt-a Hugo and World Fantasy award nominated talent to watch Whoever is born here, is doomed to stay 'til death.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |