Answer Detail: RE: Import Data with More than One Delimiter

Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question

GeekInterview.com > Tech FAQs > DataStage

Print |

Question: Import Data with More than One Delimiter

Answer: DataStage can accept more than one delimiter. How to import data if it contains more than one delimiter?

September 09, 2009 06:42:44	#1
veer.dwh	Member Since: July 2009 Total Comments: 27
RE: Import Data with More than One Delimiter
DS supports more than one delimiter, if file has more then one delimiter. to read multiple delimeters from flat file, define flat file type as fixed width. Suppose your flat file has data below cust_no,name\|phno 100,x\|10000 200,y,20000 if you specify flat file type as fixd width it will read as first data length "," as one column and second second data length as "\|" one column. Regards, Veeru.

Back To Question