Answer Posted / rr
Star schema has denormalised dimension tables connected to
a single fact table.
Snow flake schema has normalised dimension tables.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is informatica?
how to load rows into fact table in data warehouse
can u give example for factless fact table
How are indexes created after completing the load process?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Enlist few areas or real-time situations where informatica is required.
What are the tasks that source qualifier perform?
What is the maplet?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain in detail scd type 2 through mapping.
What is olap (on-line analytical processing?
What are roles and groups and benefits of using them?
explan ur project architecture?
What happens when a session fails and you click on recover?