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 is informatica metadata and where is it stored?
Parameter and variable differences
What is enterprise data warehousing?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
how to load rows into fact table in data warehouse
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
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain the scenario which compels informatica server to reject files?
How will the document be delivered to me?
explain about unit testing? in real time?
what is unit testing?tell me proceedure
EXL informatica Questions
what is the hint? how to use it to reduce the query processing in program?
how many types of dimensions are available in informatica?