Tell me how many tables used in Ur project and how many fact
tables and dimension tables
used in ur project
- 2 Answers
- 6917 Views
- iGate, Qualcomm, I also Faced
- E-Mail Answers
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
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a connected transformation?
What do you mean by channel change?
design of staging area?
explain abt ur project architecture?
What are the restrictions of union transformation?
What is a dimensional model?
How to do unit testing in informatica? How to load data in informatica ?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How many types of sessions are there in informatica.please explain them?
Explain what is informatica metadata and where is it stored?
How big was your fact table
What are the components of workflow manager?
What can we do to improve the performance of informatica aggregator transformation?
Write the advantages of partitioning a session?
