in which situations do u go for snowflake schema ?

Answer Posted / giri

it will used at time u will maitain normalised data u r
data having more cordinality dat tables

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many dimensions are there in informatica?

623


How to join three sources using joiner?

562


How to go to the older version for a mapping?

593


Explain joiner transformation in informatica

662


what is the hint? how to use it to reduce the query processing in program?

6271






hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9156


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

637


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1025


What are the differences between oltp and olap?

544


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

594


In warehouses how many schemas are there?

576


How many transformations can be used in mapplets.

1450


How to use pmcmd utility command?

574


How to create Target definition for flat files?

748


What is meant by incremental aggregation?

576