Answer Posted / joyce
In short, like our friend said: It´s a fact table with no
measures, only dimensions. That´s it.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what is pmrep command?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What are the three tiers in etl?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
tell me few points when u become TL
when will use SQL override in a lookup transformation?
What do you understand by active and passive transformations?
what is the difference between cubes and package in cognos
Define slowly changing dimensions (SCD)?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
how to connect to a flatfile through ftp in informatica
what are the reports developed in sap bw project and what is the requirement for developing it?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What are dimensions?