In dimension and fact table? which one holds big data?
Answers were Sorted based on User's Feedback
Answer / ravikumar2614
Fact table having huge data with less colomns..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / davankumar
Fact table has the big data bcoz fact table main tain
history data.
| Is This Answer Correct ? | 2 Yes | 1 No |
Why should we use star schema in datawarehouse design?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
What is sequence generator transformation in informatica?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
how to calculate the optimum cache size in aggregator transformation?
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
What are mapplets? How is it different from a Reusable Transformation?
How to generate the HTML output using Informatica.
Explain factlessfact table with scenario