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 advantages of using informatica as an etl tool over teradata?

567


Differentiate between Load Manager and DTM?

1665


What is the use of source qualifier?

671


What is blocking transformation?

718


can we override a native sql query within informatica? How do we do it?

652






Define joiner transformation?

596


Which is the t/r that builts only single cache memory?

711


Explain lookup transformation source types in informatica

700


how tokens will generate?

1738


Enlist some properties of sessions.

629


Tell me about MD5 functions in informatica

524


What is a filter transformation and why it is an active one?

562


How might you approve all mappings in the archive all the while?

602


Performance tuning( what you did in performance tuning)

1489


Under what conditions selecting sorted input in aggregator will still not boost session performance?

638