Home | BA-Interview-Questions  | Jobs | Resumes  | BA-Dictionary | Contact | Privacy Policy

 

Resources:

..

 

..

aa

 

Data Mapping & Data Modelling

 

 

Data model / Mapping document.

This section talks about how many tables are there and what data is lying in what table and what tables are there in production server? And also describes the relation between all the tables and how they are linked each other…etc..

Data Mapping:

It is basically the connection between deployment and production server.  That is table names may differ in two servers but data will be same. Mapping between the tables that have the same data.

SQL queries:

There are two types of operations in SQL. One is retrieval and other is modification. Where as BA only works with retrieval and not with modifications. 

Ex: select customer_name from CUST where dept = 10.

The above statement retrieves all customers from CUST table who belong to department 10.

 

 

photo