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
- 6458 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 |
what is the procedure for scheduling conditional rendering?
These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com
What are all the advantages of Cognos?
What is Cardinality
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
In framework Manager, what is a stitch query and is it good or bad?
What is loop in frameworkmanager ?
how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?
What is the difference between the content store and content manager?
Can we create a web page where the report directory and the output can be viewed directly across cognos connection?
How create measures and dimensions?
what is an sid (surrogate key)?
Teradata 
