Import Data with More than One Delimiter

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

Questions by krkreddys   answers by krkreddys

Showing Answers 1 - 1 of 1 Answers

veer.dwh

  • Sep 23rd, 2009
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions