Answer Posted / maruthi
DIMENSION TABLE CONTAINS DISTRIBUTTED DATA OR MASTER
DATA,WHICH WE CAN ANALYZE DEPENDING ON FFACTS OR MEASURES
IN FACT TABLE.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
According to his methodology what all you need before you build a datawarehouse
What is joiner transformation in informatica?
What do you mean by blocking transformation?
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?
Is it possible to define a single node as a Gateway node as well as worker node?
What is union transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is an unconnected transformation?
What is target designer and target load order?
How we can use union transformation?
Differentiate between a repository server and a powerhouse?
What is dimensional table? Explain the different dimensions.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Enlist the advantages of informatica.