What is confirmed dimension and fact?

Answer Posted / praveen kumar pendekanti

If a dimension exists in more than one fact table is known
as confirmed dimension. For every fact table confirmed
dimension should be there ex:: Time dimension....

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

797


can u give example for factless fact table

5505


How can you validate all mappings in the repository simultaneously?

749


What is flashback table ? Advance thanks

1476


What is the need of etl tools?

600






Explain the difference between a data warehouse and a data mart?

592


What is Data Caches size?

652


How are indexes created after completing the load process?

979


What is the command used to run a batch?

568


What is a repository manager?

642


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

615


Target increases every day even though no new record was inserted

1100


What is workflow monitor?

586


How to create a non-reusable instance of reusable transformations?

670


Differentiate between a repository server and a powerhouse?

567