Tell me how many tables used in Ur project and how many fact
tables and dimension tables
used in ur project
- 2 Answers
- 7344 Views
- iGate, Qualcomm, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Define enterprise data warehousing?
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
What are the phases in SDLC?
which one is better performance wise joiner or look up
How to load last 10 records of flat file in to the target?
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
What is a filter transformation and why it is an active one?
What are the types of lookup transformation?
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
What are the types of caches in lookup? Explain them.
Can we insert ,update ,delete in target tables with one update strategy tran.?
Teradata 
