What is confirmed dimension with scenario



What is confirmed dimension with scenario..

Answer / rajeshkumar

A conformed dimension can exist as a single dimension table that relates to multiple fact tables within the same data warehouse, or as identical dimension tables in separate data marts. Date is a common conformed dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning when joined to any fact table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,


what is datamart

4 Answers   IBM, Informatica,


How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,


What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  


How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,






how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,


How does the server recognize the source and target databases. Elaborate on this.

1 Answers  


who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  


i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,


if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,


what is diffrence b/w joner and union transfermation

6 Answers  


How many repositories can we create in Informatica?

3 Answers  


Categories