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
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What does update strategy mean, and what are the different option of it?
What are the designer tools for creating transformations?
What is transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
Where can we find the throughput option in informatica?
can u give example for factless fact table
While migrating the data from one environment to another environment how would you manage the connections?
What are the types of schemas we have in data warehouse.
Describe the impact of several join conditions and join order in a joiner transformation?
What is the reusable transformation?
In warehouses how many schemas are there?
How can a transformation be made reusable?
Explain lookup transformation is active in informatica
What is an unconnected transformation?