ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_modified' , "ActaValue_2" = 'Wed Aug 29 02:00:41 2012' , "ActaName_3" = 'RDate_created' , "ActaValue_3" = 'Mon Jun 11 05:53:11 2012' )
CREATE DATAFLOW AIG_Claim_Policy_CATASTROPHE_DF::'6b50d6e6-f8d4-4d90-9f6f-74c913169b75'

BEGIN 
ALGUICOMMENT( x = '256', y = '-325',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>363</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-174</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '39', InputSchema_WidthProp = '33', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '80', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Description', Input_2nd_Column_Name = 'Type', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = '' )
GUID::'ed0e4cc4-4cfb-4933-b44a-10784b014d81' READ TABLE DS_AIG_iVOS_SOURCE.KEENAN.CLAIM  OUTPUT ( CLAIM ) SET (
"Initial_Load" = 'no',
"array_fetch_size" = '1000',
"cache" = 'yes',
"connection_port" = 'no',
"enable_partitioning" = 'no',
"name" = 'DS_AIG_iVOS_SOURCE',
"package_size" = '0',
"reader_is_DB2CDC_table" = 'no',
"reader_overflow_file" = 'overflow_file',
"reader_template_table" = 'no',
"reader_use_overflow_file" = 'no',
"reader_use_trex_transaction" = 'no',
"table_weight" = '0',
"teradata_bulk_rdr_cleanup" = 'yes');
ALGUICOMMENT( x = '244', y = '-585',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>356</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-174</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '39', InputSchema_WidthProp = '33', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '80', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name' )
GUID::'273e0a27-000b-439e-852e-f8f76ad1147d' READ TABLE DS_AIG_iVOS_SOURCE.KEENAN.CLAIMANT  OUTPUT ( CLAIMANT ) SET (
"Initial_Load" = 'no',
"array_fetch_size" = '1000',
"cache" = 'yes',
"connection_port" = 'no',
"enable_partitioning" = 'no',
"name" = 'DS_AIG_iVOS_SOURCE',
"package_size" = '0',
"reader_is_DB2CDC_table" = 'no',
"reader_overflow_file" = 'overflow_file',
"reader_template_table" = 'no',
"reader_use_overflow_file" = 'no',
"reader_use_trex_transaction" = 'no',
"table_weight" = '0',
"teradata_bulk_rdr_cleanup" = 'yes');
ALGUICOMMENT( x = '253', y = '-887',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>375</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-174</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '39', InputSchema_WidthProp = '33', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '80', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name' )
GUID::'cd54c380-6da8-4a7b-b761-5f7c845e21c7' READ TABLE DS_AIG_iVOS_SOURCE.KEENAN.COVERAGE  OUTPUT ( COVERAGE ) SET (
"Initial_Load" = 'no',
"array_fetch_size" = '1000',
"cache" = 'yes',
"connection_port" = 'no',
"enable_partitioning" = 'no',
"name" = 'DS_AIG_iVOS_SOURCE',
"package_size" = '0',
"reader_is_DB2CDC_table" = 'no',
"reader_overflow_file" = 'overflow_file',
"reader_template_table" = 'no',
"reader_use_overflow_file" = 'no',
"reader_use_trex_transaction" = 'no',
"table_weight" = '0',
"teradata_bulk_rdr_cleanup" = 'yes');
ALGUICOMMENT( x = '1222', y = '-631' , ui_acta_from_schema_0 = 'CLAIM'  , ui_acta_from_schema_1 = 'TEMP_AIG_SELECTION'  , ui_acta_from_schema_2 = 'CLAIMANT'  , ui_acta_from_schema_3 = 'COVERAGE'  , ui_display_name = 'Q_Extract_Data'  , ui_where_text = 'CLAIM.CLAIM_ID=CLAIMANT.CLAIM_ID and 
CLAIMANT.CLAIMANT_ID=TEMP_AIG_SELECTION.CLAIMANT_ID and
CLAIMANT.COVERAGE_ID=COVERAGE.COVERAGE_ID' ,UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>291</CX><CY>-164</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-174</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '39', InputSchema_WidthProp = '33', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '80', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Description', Input_2nd_Column_Name = 'Type', Input_Column_Name_3 = 'Business_Name', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Description', Output_2nd_Column_Name = 'Type', Output_3rd_Column_Name = 'Mapping', Output_Column_Name_4 = 'Business_Name', Output_Column_Name_5 = 'Business_Name', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'5211c74c-3a15-4ac3-9733-54769f944c87' CREATE VIEW Q_Extract_Data ( CLAIM_ID decimal(28,7) SET("ui_mapping_text"='CLAIMANT.CLAIM_ID') ,
 CLAIMANT_ID decimal(28,7) KEY  SET("ui_mapping_text"='CLAIMANT.CLAIMANT_ID') ,
 POLICY_ID int SET("ui_mapping_text"='COVERAGE.POLICY_ID') ,
 Policy_Num int SET("ui_mapping_text"='ifthenelse(  CLAIM.CATASTROPHE_CODE is null ,0,COVERAGE.POLICY_ID)') ,
 CATASTROPHE_Code varchar(4) SET("ui_mapping_text"='CLAIM.CATASTROPHE_CODE')  ) 
AS SELECT  CLAIMANT.CLAIM_ID
 
 ,
 CLAIMANT.CLAIMANT_ID
 
 ,
 COVERAGE.POLICY_ID
 
 ,
 ifthenelse(  CLAIM.CATASTROPHE_CODE is null ,0,COVERAGE.POLICY_ID)
 
 ,
 CLAIM.CATASTROPHE_CODE
 
 
	FROM  CLAIM, TEMP_AIG_SELECTION, CLAIMANT, COVERAGE 
	WHERE CLAIM.CLAIM_ID=CLAIMANT.CLAIM_ID and 
CLAIMANT.CLAIMANT_ID=TEMP_AIG_SELECTION.CLAIMANT_ID and
CLAIMANT.COVERAGE_ID=COVERAGE.COVERAGE_ID
 
 ORDER BY  COVERAGE.POLICY_ID asc SET (
"distinct_run_as_separate_process" = 'no',
"group_by_run_as_separate_process" = 'no',
"join_run_as_separate_process" = 'no',
"order_by_run_as_separate_process" = 'no',
"run_as_separate_process" = 'no');
ALGUICOMMENT( x = '1703', y = '-784',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>435</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-174</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '39', InputSchema_WidthProp = '33', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '80', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'750873a0-f7c6-4027-9c4f-490eec6a74f5' LOAD TABLE BI_TAS.BI_TAS_ADMIN.POLICY_CATASTROPHE_CNT_TMP  INPUT ( Q_Extract_Data ) SET (
"connection_port" = 'no',
"ldr_configuration_enabled" = 'yes',
"ldr_configurations" = '<?xml version="1.0" encoding="UTF-8"?>
<LDRConfigurations>
<LDRConfiguration database_type="Oracle" database_version="Oracle 9i">
<bulk_col_delimiter>/127</bulk_col_delimiter>
<bulk_ldr_cleanup>yes</bulk_ldr_cleanup>
<bulk_ldr_control_file_name></bulk_ldr_control_file_name>
<bulk_ldr_direct></bulk_ldr_direct>
<bulk_ldr_direct_api></bulk_ldr_direct_api>
<bulk_ldr_generate_files_only></bulk_ldr_generate_files_only>
<bulk_ldr_max_bind_array>100000</bulk_ldr_max_bind_array>
<bulk_ldr_max_discards>10</bulk_ldr_max_discards>
<bulk_ldr_mode>append</bulk_ldr_mode>
<bulk_ldr_recoverable></bulk_ldr_recoverable>
<bulk_ldr_rows_per_commit>1000</bulk_ldr_rows_per_commit>
<bulk_ldr_trailing_nullcols></bulk_ldr_trailing_nullcols>
<bulk_ldr_use_control_file></bulk_ldr_use_control_file>
<column_delimiter>,</column_delimiter>
<enable_partitioning>no</enable_partitioning>
<ignore_column_case>yes</ignore_column_case>
<ignore_columns_null>no</ignore_columns_null>
<ignore_columns_value></ignore_columns_value>
<loader_auto_correct>no</loader_auto_correct>
<loader_bulk_load></loader_bulk_load>
<loader_compare_column>compare_by_name</loader_compare_column>
<loader_delete_map></loader_delete_map>
<loader_drop_and_create_table>yes</loader_drop_and_create_table>
<loader_insert_map></loader_insert_map>
<loader_insert_select_commit_size>yes</loader_insert_select_commit_size>
<loader_load_choice>append</loader_load_choice>
<loader_num_parallel_loaders>1</loader_num_parallel_loaders>
<loader_overflow_file>overflow_file</loader_overflow_file>
<loader_post_load1></loader_post_load1>
<loader_pre_load1></loader_pre_load1>
<loader_quote_names>0</loader_quote_names>
<loader_transactional>no</loader_transactional>
<loader_transactional_order>0</loader_transactional_order>
<loader_update_key_columns>no</loader_update_key_columns>
<loader_update_map></loader_update_map>
<loader_use_user_defined_keys>no</loader_use_user_defined_keys>
<loader_xact_size>1000</loader_xact_size>
<oracle_auto_correct_using_merge>yes</oracle_auto_correct_using_merge>
<oracle_bulk_ldr_all_method>None</oracle_bulk_ldr_all_method>
<oracle_bulk_ldr_file_method>None</oracle_bulk_ldr_file_method>
<oracle_bulk_ldr_method>None</oracle_bulk_ldr_method>
<oracle_bulk_ldr_method_api>API</oracle_bulk_ldr_method_api>
<oracle_bulk_ldr_method_file>File</oracle_bulk_ldr_method_file>
<oracle_bulk_ldr_method_none>None</oracle_bulk_ldr_method_none>
<oracle_bulk_ldr_mode_api>append</oracle_bulk_ldr_mode_api>
<oracle_bulk_ldr_use_local_index_for_pkey>no</oracle_bulk_ldr_use_local_index_for_pkey>
<oracle_sqlldr_version></oracle_sqlldr_version>
<overflow_file_format>write_data</overflow_file_format>
<overriding_substitution_parameter_for_tablename></overriding_substitution_parameter_for_tablename>
<text_delimiter></text_delimiter>
<use_overflow_file>no</use_overflow_file>
<use_unicode_varchar>no</use_unicode_varchar>
<sql_text></sql_text>
</LDRConfiguration>
</LDRConfigurations>',
"loader_template_table" = 'yes',
"name" = 'BI_TAS',
"use_unicode_varchar" = 'no');
ALGUICOMMENT( x = '369', y = '-1243',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>363</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-167</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '59', InputSchema_WidthProp = '48', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '80', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Description', Input_2nd_Column_Name = 'Type', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = '' )
GUID::'9dde6322-0881-4afa-822a-005c824ec74e' READ TABLE DS_AIG_iVOS_SOURCE.VOSUPPORT.TEMP_AIG_SELECTION  OUTPUT ( TEMP_AIG_SELECTION ) SET (
"Initial_Load" = 'no',
"array_fetch_size" = '1000',
"cache" = 'yes',
"connection_port" = 'no',
"enable_partitioning" = 'no',
"name" = 'DS_AIG_iVOS_SOURCE',
"package_size" = '0',
"reader_is_DB2CDC_table" = 'no',
"reader_overflow_file" = 'overflow_file',
"reader_template_table" = 'no',
"reader_use_overflow_file" = 'no',
"reader_use_trex_transaction" = 'no',
"table_weight" = '0',
"teradata_bulk_rdr_cleanup" = 'yes');
END

SET("Cache_type" = 'pageable_cache',
"Parallelism_degree" = '0',
"allows_both_input_and_output" = 'yes',
"run_once" = 'yes',
"use_datastore_links" = 'yes',
"validation_xform_exists" = 'no',
"validation_xform_stats" = 'no')