What is Lookup ,bridgeing tables where they will use in the
Dataware house
- 2 Answers
- 5831 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 |
Can you define pivot?
hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........
pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com
what is the security module used in cognos?
----------------What is Surrogate Key?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
how to create relationship between emp and salgrade tables in frameworkmanager?
how to connect datamarts
What is a Datastore in Cognos?
what is loop in frameworkmanager ?
what is log in cognos?
Can you define dimension?
Teradata 
