DSXchange

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

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

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"

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