Uploaded Documents
4
DemoETL Validation Workspace
Upload ETL requirements and generate SQL and Oracle validation scripts.
Extracted Rules
28
ReadyGenerated SQL Checks
42
ReadyOracle Statements
18
ReadyReconciliation Scenarios
12
ReadyUploaded Artifacts
Sample/demo data shown until Supabase is configured.
Loading uploaded artifacts...
Extracted Analysis Overview
View AllSource-to-Target Mappings
16
Transformation Rules
28
Join Conditions
14
Null Handling Rules
11
Aggregation Logic
9
Data Quality Constraints
23
Generated Validation SQL
1-- 1. Row Count Validation: Source vs Target
2SELECT 'COUNT' AS chk_type,
3 'TAR1' AS target_table,
4 (
5 SELECT COUNT(*) AS src_count
6 FROM SRC_PAYMENTS_STG
7 WHERE TRUNC(LOAD_DT) = :LOAD_DATE
8 )
9 -
10 (
11 SELECT COUNT(*) AS tgt_count
12 FROM TGT_PAYMENTS_DW
13 WHERE TRUNC(LOAD_DT) = :LOAD_DATE
14 ) AS count_diff,
15 CASE
16 WHEN (
17 SELECT COUNT(*)
18 FROM SRC_PAYMENTS_STG
19 ) > 0
20 THEN ROUND(
21 (
22 (
23 SELECT COUNT(*)
24 FROM TGT_PAYMENTS_DW
25 )
26 -
27 (
28 SELECT COUNT(*)
29 FROM SRC_PAYMENTS_STG
30 )
31 )
32 /
33 (
34 SELECT COUNT(*)
35 FROM SRC_PAYMENTS_STG
36 ) * 100,
37 2
38 )
39 ELSE NULL
40 END AS pct_diff,
41 'ROW_COUNT_CHECK' AS check_name,
42 'PAYMENTS_DW' AS src_system
43FROM DUAL;
Recommended Validation Packs
View all validation packs →Execution Readiness
82%
Automatable
34
82%
Ready for execution
Needs Mapping Review
6
14%
Review mappings
Manual Review
2
4%
Requires manual review
Next Step
Select validation packs and generate scripts to start execution.