Skip to Content
0
Aug 14, 2015 at 10:52 PM

BODS dataflows that have truncate

138 Views

Experts,

I'm looking to get a list of dataflows where the target tables have the bulk loader option set to 'truncate'.

So I can get the dataflow - target relationship as follows:

select

PARENT_OBJ, PARENT_OBJ_TYPE, DESCEN_OBJ, DESCEN_OBJ_TYPE, DESCEN_OBJ_USAGE, DESCEN_OBJ_DS, DESCEN_OBJ_OWNER FROM AL_PARENT_CHILD

WHERE DESCEN_OBJ_TYPE = 'Table'

AND DESCEN_OBJ_USAGE = 'Target'

But I'm not seeing a metadata table the shows me if the bulk loader is set to truncate.

Anyone know what table that's in?

Mike