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
What are the types of lookup transformation?
What is a standalone command task?
What is a transaction control transformation?
How to do unit testing in informatica? How to load data in informatica ?
explan ur project architecture?
Differentiate between a database and data warehouse?
what is the difference between informatica6.1 and infomatica7.1
can u give example for factless fact table
Explain the aggregator transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How are indexes created after completing the load process?
Mention few power centre client applications with their basic purpose?
what is SDLC way of code development?
Different sorts of metadata that stores in the storage facility?
How big was your fact table