Please enable JavaScript.
Coggle requires JavaScript to display documents.
EBT Flown (PROVISIONAL (Ingestion, Modelling and Export to be validated…
EBT Flown
PROVISIONAL
Ingestion, Modelling and Export to be validated similar to Weekly process.
Table in RAPID is CVWPAXDOCPRO from where the data will be pulled with DOCTYP = 'EBT' or SRVTYP in ('EB', 'IE').
Validate if data is unavailable in RAPID for the day of processing, it waits for 3 days and if still not available, then fails
Data should be with flnmth = processing_month - 1.
Example: If processing month is Feb 2018, then Provisional data should be with flnmth as JAN 2018
WEEKLY
01.Ingestion
Ingested from RAPID - CVWPAXDOCWLY table with DOCTYP = 'EBT' or SRVTYP in ('EB', 'IE')
-
-
-
Check if same day the process is run, it fails as the weekly data is already fetched and logged in the control file
-
Check if the ingestion is done for the week whose start_date_time in the RAPID's cvwctllog table is same as the run date and the PROSTA column value is set to 'S'
Check if ingestion fails in case the PROSTA value is 'F' in the cvwctllog table and an email is sent to helix support mail box with the message "to contact support team and run the process manually"
-
-
-
02.Modelling
-
Modelled file path to be under 'Reference_data' under ek_airline_genome folder
Table should be created under ek_airline_genome_public database
-
03.Export
-
-
Data validation between EDH and Exadata - column to column level and Metrics level to ensure no data loss
Data formats, amount related field values to also be validated if format is as defined in ICD
PREFINAL
Ingestion, Modelling and Export to be validated similar to Weekly process.
Table in RAPID is CVWPAXDOCPREFIN from where the data will be pulled with DOCTYP = 'EBT' or SRVTYP in ('EB', 'IE').
Data should be with flnmth = processing_month - 2.
Example: If processing month is Feb 2018, then PreFinal data should be with flnmth as DEC 2017
FINAL
Ingestion, Modelling and Export to be validated similar to Weekly process.
Table in RAPID is CVWPAXDOC from where the data will be pulled with DOCTYP = 'EBT' or SRVTYP in ('EB', 'IE').
Data should be with flnmth = processing_month - 3.
Example: If processing month is Feb 2018, then Final data should be with flnmth as NOV 2017
HISTORY
02.Modelling
-
Modelling file path to be under 'Reference_data' under ek_airline_genome folder
Table should be created under ek_airline_genome_public database
-
Metrics level checks between source, decomposed and modelled files to ensure data has not been lost
Validate the ASSOCIATED_TICKET_NUMBER column addtion - which is the concatenated value of ICNCARCOD and ICNDOCNUM as defined in Exadata ICD
-
03.Export
-
-
Data validation between EDH and Exadata - column to column level and Metrics level to ensure no data loss
-
Data formats, amount related field values to also be validated if format is as defined in ICD