Viewing 15 posts - 1 through 15 (of 80 total)
Hi again,
I found even better solution...?
TRY_CONVERT returns 0 from some of the decimals with comma but try_parse seems to be consistent...
TRY_PARSE(REPLACE(Value, ',', '.') AS...
March 27, 2018 at 5:45 am
Hi,
no, but just did. Thank you, that opened my blind spot...
In this particular CSV file I returned Value instead of REPLACE(Value, ',', '.') from the first...
March 27, 2018 at 5:24 am
Hi,
yes, that is what happens..but what then? What can i do?
isNumeric not reliable..how can i the find what Value might cause this?
v
March 27, 2018 at 5:08 am
Hi,
yes I agree, it is not a hashbytes problem. instead Informatica removes the two trailing zeroes when inserting the row to db. Why..? Remains a mystery.
ville
December 28, 2017 at 11:48 am
Hi,
OK. Binary(16) would solve the problem. There is only one minor problem...there is a big DataVault solely based on varbinary(40) fields - too big a job to start...
December 28, 2017 at 11:14 am
Hi,
yes so it seems...
The difference is that in my case the insert goes through Informatica ETL tool. There is something with the Unix ODBC API or...
December 14, 2017 at 10:29 pm
December 14, 2017 at 10:21 pm
I hope it would but I don't think so. At least not from DB perspective not and can't see why DataPower would/could deny anything from certain customers...
November 18, 2016 at 6:43 am
They have DataVault 2.0 and it is requested to have a HASHed dv_key...
v
November 18, 2016 at 6:25 am
Hi,
if anybody is interested then here is what I did as a workaround and some other findings as well
First of all, I finally got it that actually the HASHBYTES has...
November 18, 2016 at 4:18 am
Hi,
the columns are varbinary(40) in DB and ETL
I form the dv_key in Sql view like seen up there and it was done similarly both times.
There are 21 rows in this...
November 18, 2016 at 1:04 am
Post deleted and transferred under 2012 general
October 22, 2015 at 9:13 am
Thank you! This 5 dll copying saved my day!
April 9, 2015 at 5:05 am
Yes, thanks, I learned that today. I need to download
April 8, 2015 at 8:19 am
FYI
some of the packages I needed to recreate completely...luckily the ones where simple dim update else insert packages....
Never happened before
V
February 12, 2015 at 2:15 pm
Viewing 15 posts - 1 through 15 (of 80 total)