PD16.5 Generating Oracle PDM -> Hive PDM & Conditional Datatype Conversion

[former_member552607]

Hi Folks,

I have been searching for a way of changing certain datatypes when generating a new Hive PDM (Hive dbms Definition) from an existing Oracle PDM.

I have added various conversions in the HIVE10::Script\DataType\AmcdDataType definition file, example below:

Internal	Physical Model
N%s,%p	decimal(%s,%p)
VA%n	varchar(%n)

But what I am actually tying to do is to conditionally change the type/size of datatypes when generating a new Hive PDM from an existing Oracle PDM; See  below.

Oracle nunber(1 to 9) to Hive int datatype

Oracle number(10 to 19) to Hive bigint datatype.

Oracle number(20 +) to Hive decimal.

Oracle number(10,2) to Hive decimal(10,2)

I could just do it manually through the "List of Columns" and block changes, but I would have to do this exercise every time I generate a new PDM, that requires this formatting.

Has anybody done the type of conditional formatting before, or any pointers?

many thanks

[Former Member · Accepted solution]

Try using transformations.