![]() ![]() Only one thing we need to take care while splitting third column data we have to start from second occurrence of comma till fouth occurrence of comma. ![]() While Importing File metadata of source file in Flat File Import wizard Step 2 of 3 Check Treat consecutive delimiter as oneĪpproach 2: Read complete file as fixed width and in the expression with the help of SUBSTR() and INSTR() function split into columns. Informatica has already provided an option to handle this case. ĬASE 1: More than one Comma is appearing just after delimiter Ex: Address column has data like this 'CA,USA'ĬASE 3: Any other Char like Char is appearing anywhere in data. If not then what changes needs to be done to make it fit for source or even sometimes we need to push it back to client with reason that data is not in a format which would be treated like a source as per requirement.ĬASE 1: More than one Comma is appearing just after delimiter ĬASE 2: Comma is appearing in a data itself. First of all, we need to do data profiling for our source file.ĭata Profiling is a validation process through which we are analyzing the data whether it's fit for source or not. Theory Analysis: There are multiple cases in this. Scenario 16: How to handle comma in a comma delimited file? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |