Interested to Buy Any Domain ? << Click Here >> for more details...
Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse
- 5 Answers
- 25493 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
it depends upon the requirement of the client . dimension
table is loaded first , using the primary keys of the
dimension table , fact tables are loaded .size of the fact
and dimension table also depends upon the requirement .
size of the table and warehouse also depends upon clients
requirement .
| Is This Answer Correct ? | 17 Yes | 2 No |
Answer / abhishek
ranjan is right its all depend on that how many years old
data u are going to keep in your warehouse
first dimension will load and then on base of dimension we
load fact table
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / rajupatel
Dimension will be loaded first then fact,
Table size: Dimenstion > fact
Number of Records: fact > dimention
Size: Table < DWH
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / dhana
Can anyone please tell me the No. of Fact table & Dimension tables usually used in a prjoect?I just need an example.Also the size of data warehouse?Is it in Terabyte of something?I just need an approximate size.
Thanks
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bsgsr
hi, raju patel.
ur answers are thoughtful. they reflect ur intellect which
is very stimulating and vibrant. i am pretty impressed with
your answers.
i believe you have good experience with the industry. since
when have you been working with the industry. can i have
some of my queries cleared only if you dont
minddddddddddddddddd!!!!!!!!!!!!. revert back to me on my
id bsgsr12@gmail.com also provide me your number if you
dont mind. take care
| Is This Answer Correct ? | 1 Yes | 10 No |
What is transformation?
How are indexes created after completing the load process?
How can you join two tables without any common column present in them?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
What is fact table? Explain the different kinds of facts.
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
What is the difference between a repository server and a powerhouse?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
What is active and passive transformation?
Explain load alternative records / rows into multiple targets - informatica
Please let me know how to make encryption and decryption with example?
Teradata 
