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 ? | 4 Yes | 0 No |
Post New Answer View All Answers
Define enterprise data warehousing?
What are the designer tools for creating transformations?
how many types of dimensions are available in informatica?
Explain sql transformation in script mode examples in informatica
What is the meaning of up gradation of repository?
How you can differentiate between connected lookup and unconnected lookup?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How to differentiate between the active and passive transformations?
Does an informatica transformation support only aggregate expressions?
What is the difference between source qualifier transformations source filter to filter transformation?
What is primary and backup node?
explain abt ur project architecture?
When do you use sql override in a lookup transformation?
Define Pmrep command?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?