Dimensional modelling vs data modelling vs er modelling
What is dimensional modelling ? What is the difference between data modelling and dimensional modelling and erwin modelling.
What is the need for an ods(operational data store)
What is the need for an ods(operational data store) in data warehousing?What are the advantages of using an ods?
The need for ODS is to clean the data coming from hetrogenous sources. To maintain data quality for better warehouse which provides good reporting.
The Data cleaning tool name which is been widely used unliked Informatica (ETL tool ) name is FirstLogic.
How do you run sessions one after another?
There are two methods for running the session one is to run concurrently and second one is to run sequentially which you want to do. There are three things need to be configured at properties lev...
What are the differences between meta data and data dictionary?
The “data dictionary” in a database tool (eg. Oracle or Informatica) is simply a repository of metadata. Metadata is however data about the data. The following are examples of m...
HI Metadata is nothing but the data about data , if you take term of informatica in that through metadata only you will be converting or solving the problem. In the flow of Informatica mapp...
How do we move mappings from development environment to testing environment and from there to production?
Export your mappings into XML, place it in your local folder then go the next environment and import the xml mappings you've exported.
Dear Friend,Migration of mappings are very delicate things. In this process you need to take backup of repository if it is test to QA and from QA to Production as you mentioned.Follow on i would like ...
Hi, this is ram working as a system administrator I had installed the Informatica powercenter 7.1.1 and when I was configuring the repository server it is giving "the server could not contact" message, I never faced this problem before pls anybody had any solution pls send to me as early as possible...
Hi Ram,You could first go to repository manager give relational connection and then you could configure server add new and give details.Give port name as defined in the configue repository serve...
At the time of configuring the repository server just give the port number is 5001 and put a passwordThen start the service first then open the repository server administrator console.Just connect it ...
Unable to start my Informatica repository service windows XP and Oracle 10g
I am unable to start my Informatica repository service, even if I start the service, it stops immediately.Please, any one have a solution to this problem(i installed Informatica 7.1 on windows XP home edition, Oracle 10g)thanks a lot.Nagesh
Software could be corrupted or has attacked with Virus,
Re-install and if the problem persist then you change the OS and try Informatica, it may work.
In order to up your IRS, please follow up the guidelines:- 1) Create a database, if u have already DB exist, then u can go with the same. 2) Create two db users, give admin privilege to those users....
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
NH
Modeling is nothing but designing the database by using any Database Normalization techniques (1NF, 2NF, 3NF.......etc)Data Modeling is having 2 types:1. ER Modeling2. Dimensional ModelingER Modeling ...
Dimensional modelling sometimes mistaken as the ER modelling but no it is wrong, DM is just modelling which is more flexible for the user perspective.In ER it is not mapped unlike DM for creating sche...