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

How to create a dynamic column name in Cognos?

6 Answers   Aditya Birla, Polaris,

---

can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?

1 Answers  

---

How to Reset Pagenumbers in one report.

0 Answers  

---

What is meant by Tabular SQL in Cognos Report net

3 Answers   Infosys,

---

What is power prompts?Can somebody explain me.

2 Answers  

---

in which scenario we go for views in cognos or oracle?

1 Answers  

---

i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....

2 Answers  

---

----------------Diff b/w Dimensional modeling and Relational modeling?

2 Answers   Cap Gemini, L&T,

---

what is difference btw summary filter and detail filter, plz explain with example

10 Answers   IBM, TCS,

---

..Architectural difference between cognos reportnet and cognos8?

3 Answers  

---

What is Performance Tunning Test?

2 Answers   IBM,

---

-------------------What is Deployment?

2 Answers   IBM,

---