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

wt is the differnce between Block & conditional block ?

2 Answers  

---

Can you define pivot?

0 Answers  

---

------------What is Slicer memberset?

1 Answers  

---

3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

0 Answers  

---

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

2 Answers   Patni,

---

i have a table with 3 columns country,empname,salary and i want the query for get the  name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance 

2 Answers   IBM,

---

where you can save the report net documentation in our local system?

0 Answers   IBM,

---

Can u please describe the different types of traps with eg. Thanks

2 Answers  

---

What is a Datastore in Cognos?

0 Answers  

---

Can i apply drill through on chart in report studio?

4 Answers   TCS,

---

Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You

1 Answers  

---

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

1 Answers   Thomson Reuters,

---