what is confirmed dimension?

Answer Posted / mohini

the dimention table is connect to fact table.the splitted dimention tables are also connect the fact tables.the spiltted dimention tables also carries the same meaning across the total transaction.the dimention tables contains denormalized data.ths z called confirmed dimension.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In warehouses how many schemas are there?

574


Explain the difference between mapping parameter and mapping variable?

600


How do you load only null records into target? Explain through mapping flow.

1489


How to handle decimal places while importing a flatfile into informatica?

712


hi real timers . iam waiting for ur reply regarding ETL TESTING

1798






can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2132


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

763


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4960


What is complex mapping?

629


how to load rows into fact table in data warehouse

634


What is primary and backup node?

689


Which version configuration tool used in ur project?

2761


Target increases every day even though no new record was inserted

1101


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1743


Explain what are the different types of transformation available in informatica.

564