Tell me how many tables used in Ur project and how many fact
tables and dimension tables
used in ur project

Answer Posted / davankumar

Actuvally...that can be dependinge ur project...but u have
2 say like these..In my project we have more than 100
tables but in my module we can used only 10 to 15 tables
only..
Then dimension :5 to 6 dimension tables
And 1 or 2 fact tables

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the basic requirements to join two sources in a source qualifier transformation using default join?

609


What does update strategy mean, and what are the different option of it?

581


What are the designer tools for creating transformations?

672


What is transformation?

652


what is diff b/t sorter t/r and agg have the option sorter property...

1734






Where can we find the throughput option in informatica?

598


can u give example for factless fact table

5505


While migrating the data from one environment to another environment how would you manage the connections?

616


What are the types of schemas we have in data warehouse.

523


Describe the impact of several join conditions and join order in a joiner transformation?

637


What is the reusable transformation?

621


In warehouses how many schemas are there?

574


How can a transformation be made reusable?

658


Explain lookup transformation is active in informatica

653


What is an unconnected transformation?

657