OAC Data flow-do not do any ALTER TABLE to modify the length of the dataset columns

Sarika Chaudhari-Oracle

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Oracle

Description (Required):

When we run data-flow for the first time then data set will set column length.

If we do any modification i.e. adding new records or decreasing records and if this columns has more length than original length of column then it won't alter table or dataset rather it will trim the characters.

Use Case and Business Need (Required):

Use Case:

If i have source file for the dataflow is excel. For first load i have data around 10 records and Employee name is around 6 characters. After some time i have updated my excel added more records and now few name columns has increase its length to 10 and then I reran the dataflow. Now it will trim characters from newly added columns which will cross length 15.

Name : Sarika

First Load : Sarika

Updated File -> Name : Sarika Chaudhari

Second Load -> Sarika

It will not take newly added characters since length is increased.

So right now workaround is just delete dataset and rerun dataflow. But this is really painful when client is working on the system where he daily want ran dataflow with updated data from excel.

Enhancement Request / Service Request: 3-28768214361