who to split dimentions into sub dimention

Answers were Sorted based on User's Feedback



who to split dimentions into sub dimention..

Answer / srinu

make required column as primary-forign key relation then add
fields wt do u want

Is This Answer Correct ?    3 Yes 1 No

who to split dimentions into sub dimention..

Answer / vino

i Think,

You can split the dimension tables into two and can join
the two separate dimemsion tables by the surrogate key.

Is This Answer Correct ?    2 Yes 1 No

who to split dimentions into sub dimention..

Answer / kittu

It is clearly apt for snowflake schema because in snow flake schema dimension table are further splits the de-normalized table into small normalized dimensions to decrease the table space and also to increase the performance this can be done with help on foreign key and primary key constraints

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

how many data models u have done in informatica project?

2 Answers   TCS,


what is datamart

4 Answers   IBM, Informatica,


How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,


In any project how many mappings they will use(minimum)?

1 Answers  


How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  






how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,


for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,


How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  


explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,


Informatica settings are available in which file?

0 Answers   Informatica,


What do you mean by filter transformation?

0 Answers  


How many repositories can be created in informatica?

1 Answers  


Categories