what is confirmed dimension?

Answer Posted / sri ram

Conformed dimension is a dimension which is connected to or
shared by more than one fact table.

Eg:A business which takes care of both sales and orders of
products then product dimension becomes a conformed
dimension for both sales fact and order fact

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an Integration service in Informatica?

694


What is mapplet in informatica?

587


what is degenerated dimension?

3138


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6452


How union transformation is used?

579






Which files are created during the session rums by informatics server?

697


what is the -ve test case in your project.

1841


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1224


What is an expression transformation?

583


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1541


What is informatica etl tool?

542


What is mapping debugger?

563


Explain load alternative records / rows into multiple targets - informatica

671


What are the steps involved in the migration from older version to newer version of Informatica Server?

1572


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3311