Interested to Buy Any Domain ? << Click Here >> for more details...
What is Lookup ,bridgeing tables where they will use in the
Dataware house
- 2 Answers
- 6484 Views
- IBM, I also Faced
- E-Mail Answers
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 |
wat is bus schema?
suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me
How many reports did you create in your project?
what is physical layer and presentation layer?
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com
What is the use of Cognos scenario?
What is slowely changing dimensions?why we are used SCD?
How can you create prompts in framework manager?
Is there any comparison available for Cognos Reportnet Vs Crystal reports?
What is the metric store database?
which table we load first in DW. dimension or fact? why?
4 Answers IBM, JPMorgan Chase,
What is a Pivot?
Teradata 
