What is Lookup ,bridgeing tables where they will use in the
Dataware house
Answers were Sorted based on User's Feedback
Answer / palzkumar
lookup table is nothing but the table which will have two coulmns, first one will've diff values (eg. Mumbai, Bombay, Bom, Mum) sec one will've single value (like Mumbai).
Your etl mapping would be... if any values like Mum, Bom, Mumbai, Bombay then you need to populate as Mumbai.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / janni
Lookup is One Of the transformer in ETL tool.it can be used
to filter the data in Target table.
there are 2 types of lookup are there
1.connected Lookup
2.Un Connected Lookup
| Is This Answer Correct ? | 0 Yes | 2 No |
What do you understand by the term 'dynamic cube'?
Can we test the report other than manual testing?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
-----------Diff b/w OLAP and RDBMS?
---------------What is Dimension?
what is dynamic sort?
Can you explain model durability?
What is the difference between a cascading report and drill through report?
what are the dimensions that you have in your current project?list them?
Hey Techies, Could you please tell me about query processing? and what is database only and what is Limited locale? brief plz..
What is main advantage datawarehousing over oracle?
6. Which of them will increase the performance?