Answer Posted / guest
By doing check integrity we can test universe & By coping
report query and run in back end(oracle,sql server...) we
can test the data by comparing both.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What is the use of incremental aggregation? Explain me in brief with an example?
Explain the differences between normalizer and normalizer transformation?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
What is called data cleaning?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what are the various reporting tools in the market?
What is difference between query studio and report studio?
Which are the olap tools available that are supported by oracle?
Explain why denormalization is promoted in universe designing?
Define data warehouse?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What is the main difference between star and snowflake star schema? Which one is better and why?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What are data modeling and data mining? Where it will be used?