What is Lookup ,bridgeing tables where they will use in the
Dataware house
- 2 Answers
- 5640 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 |
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
What is defined as data mining?
explain project, package ,model , modelers.........and differences b/w them?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What is the use of Cognos scenario?
what is the difference between aggregation and roll up aggregation?
Can we install cognos on windows 7?
This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,
1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?
Teradata 
