Problem with Bigint when getting Nulls

karthegx · Post by **karthegx** » Fri Sep 07, 2007 5:26 am

Hi,

I have a problem when Importing the metadata for Datatype BigInt from the table.

when importing the key column from the table it writes as BigInt and NotNull.

I am using Join stage inorder to get this key When Join fails it should write Nulls.But instead of writing Nulls its writing "0"(Zero's).

How to get Nulls in this case

Thanks in Advance

ray.wurlod · Post by **ray.wurlod** » Fri Sep 07, 2007 5:29 am

Change the Nullable property on the right input and on the output links for this column to "Yes".

karthegx · Post by **karthegx** » Fri Sep 07, 2007 5:47 am

If I am changing the Nullable property the job is Aborting

and these are the warnings:

"APT_CombinedOperatorController(1),3: Conversion error calling conversion routine timestamp_from_string data may have been lost"

ray.wurlod · Post by **ray.wurlod** » Fri Sep 07, 2007 5:52 am

Unrelated issue - get the syntax of the timestamp_from_string function correct in your specification - include 'nullable' if needed.