Hi,

TOS DI 5.1.1

So I have a table in MySQL 5 with ~10 columns and some have null values

I have a simple job setup


tMysqlInput --> tMap --> tMysqlOutputBulk

(tMap here only does 1 to 1 mapping, so even without it it runs the same)

however my concern is that in Advanced setting of tMysqlOutputBulk, I cleared the check for

"Records contain NULL value" and according to the RG It says "If you clear the check box, the NULL values will automatically be replaced with empty values."

But when I look at the output file, it still has the "\N" value kept in it.

I was wondering why this was not replaced with empty value

additionally, in adv. settings

Row separator = "\n"
file separator = ","
escape char = "\"" (also tried with "\\" which made the result "\\N" instead of "\N")
Text enclosure = "\""

besides all should be pretty much default settings

2nd question is how does Text enclosure in mysqlOutputBulk work?

It looks like for a column if it has a entry like this

entry1"abcd"entry1

then in CSV file it turns out to be like this "entry1""abcd""entry1"

on contrary if I set similar setting (text enclosure) in tOracleOutputBulk, it would be what I expected "entry1"abcd"entry1"

is there any reason why they give different output?


Thanks

Last edited by yoo9189 (2012-07-04 00:23:23)