How many Dimension tables can connect to a Fact table?
Latest Answer: The number of Dimensions depends primarily on the requirement. I have built systems with a few FOUR Dimensions on a Fact and as many as TWENTY. There is no physical limit imposed by either the database or ETL tool.Kimball recommends however, ...
How to Test and Debug in Informatica
What is Dimensional modelling ? What is the difference between Data modelling and Dimensional modelling and Erwin modelling.
Latest Answer: 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 is for OLTP databases uses any of the forms 1NF or ...
What is the complete process in Informatica power center client tool? Explain using ETL tool
Latest Answer: ETL-Extraction (from Source)-Transformation-Loading (to Target)In this process There are 2 servers active at the same time 1) Informatica Server.
2) Repository ServerHere Informatica Server Connects to the Sources and Targets through Native ODBC connections, ...
What is the need for an ODS(operational data store) in data warehousing?What are the advantages of using an ODS?
Latest Answer: The need for ODS is to clean the data coming from hetrogenous sources. To maintain data quality for better warehouse which provides good reporting. ...
How do you run sessions one after another?
Latest Answer: 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 level of workflow those are 1) Expression should be valid ...
What are the advantages and disadvantages (if any) of upgrading the mappings from Informatica 7.1.3 to Informatica 8
Latest Answer: hi thereits not the matter of advantages or disadvantages for upgrading. its all depends on client requirement. if the client feel that using higer version is more comfortable and ease of use and if they find any useful features to make the proces ...
hello,could anyone please guide me ,how to link with database(oracle database or sql server),iam new to informatica, please tell me the path to link these 2 because iam practising in my homewith my computer.please
Latest Answer: hi to all infomatica people in order to link infomatica with database an infomatica developer or etlconsutant has to use ODBC Connections (open database connectivity driver)which are their in infomatica s/w i mean when u instal INFOMATICA ON UR PCfor ...
How do we move mappings from development environment to Testing environment and from there to production?
Latest Answer: Export your mappings into XML, place it in your local folder then go the next environment and import the xml mappings you've exported. ...
1.)I am creating custom profile on the relational source because it is failing to create report due database fatal error (some table name pm_dp_m doesn't exists in the repository) but when i check
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
