If we have 200 staging tables, 40 dimensions tables and 20 facts table, How will you compare it with target systems

Question

Accepted Answer

The number of staging, dimension and fact tables in source and target systems need to be compared.

Compare the number of staging, dimension and fact tables in source and target systems.
Check if the table names and column names are consistent in both systems.
Verify if the data types and data values are matching in both systems.
Ensure that the ETL process is properly mapping the data from source to target systems.
Perform data profiling to identify any discrepancies between the source and target systems.

Accepted Answer

Tyu society dp cn f gl id dfkdh jain bldg Djkgghg

Accepted Answer

if Architecture is designed using SCD Type-2, then we can pick latest record using timecard. once you know what is the latest record, pick the primary key and check this key is displayed in Target i.e. fact tables and respective data is displayed in dimensions table.

If we have 200 staging tables, 40 dimensions tables and 20 facts table, How will you compare it with target systems

Top Cognizant ETL Tester interview questions & answers

Popular interview questions of ETL Tester

Top HR questions asked in Cognizant ETL Tester