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.

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

What is the use of 'individual data source' option while using filter in query studio?

1 Answers   Thomson Reuters,

---

what is a Galaxy Schema?

2 Answers   IBM,

---

What is the Main Difference between Conditional Block and Render Variable in Cognos. Both are used for Condtional rendering.But what is the Main Diff?

4 Answers   Wipro,

---

Define the slice and dice?

0 Answers  

---

what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??

2 Answers   Satyam,

---

How to generate cubes in cognos?

0 Answers  

---

we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer

4 Answers   IBM,

---

What is a query set?

3 Answers   IBM,

---

what is the difference b/w mdx and sql?

4 Answers   Cap Gemini, IBM,

---

1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.

2 Answers   Satyam,

---

What is meant by Reportstudio shortcut?

0 Answers  

---

How to upgrade drivers in Cognos 8?

1 Answers  

---