ZCA_ESTIMATION_FEATURES

Details

Schema: FUSION
Object owner: ZCA
Object type: VIEW

Columns

Name
BATCH_ID LANGUAGE_INDEPENDENT_CODE NUM_OF_RECORDS NUM_OF_ATTRS PARALLEL_BATCHES PODCONFIG IMPORT_MODE IMPORT_TYPE TOTAL_TIME_TAKEN

Name

BATCH_ID

LANGUAGE_INDEPENDENT_CODE

NUM_OF_RECORDS

NUM_OF_ATTRS

PARALLEL_BATCHES

PODCONFIG

IMPORT_MODE

IMPORT_TYPE

TOTAL_TIME_TAKEN

Query

SQL_Statement
select batch_id,language_independent_code,num_of_records, num_of_attrs, parallel_batches, round((186/POD_CONFIG),1) podConfig, import_mode,import_type, round(TOTAL_TIME_TAKEN/60000) Total_Time_taken from zca_estimation_features where enable_ml = 'Y' and round(TOTAL_TIME_TAKEN/60000) is not null and round((186/POD_CONFIG),1) is not null and parallel_batches is not null and POD_CONFIG !=0

SQL_Statement

select batch_id,language_independent_code,num_of_records,

num_of_attrs,

parallel_batches,

round((186/POD_CONFIG),1) podConfig,

import_mode,import_type,

round(TOTAL_TIME_TAKEN/60000) Total_Time_taken

from zca_estimation_features where enable_ml = 'Y' and round(TOTAL_TIME_TAKEN/60000) is not null and round((186/POD_CONFIG),1) is not null and parallel_batches is not null and POD_CONFIG !=0