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


Please Help Members By Posting Answers For Below Questions

Define enterprise data warehousing?

638


What are the designer tools for creating transformations?

687


how many types of dimensions are available in informatica?

565


Explain sql transformation in script mode examples in informatica

609


What is the meaning of up gradation of repository?

1397






How you can differentiate between connected lookup and unconnected lookup?

619


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?

2430


How to differentiate between the active and passive transformations?

631


Does an informatica transformation support only aggregate expressions?

612


What is the difference between source qualifier transformations source filter to filter transformation?

589


What is primary and backup node?

706


explain abt ur project architecture?

1765


When do you use sql override in a lookup transformation?

591


Define Pmrep command?

642


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1625