Answer Posted / anil

Connected lookup

Unconnected
lookup

Receives input values diectly from the
pipeline

Receives input values from
the result of a

lkp expression in a
another transformation.

yoU can use a dynamic or static
cache U can use a static cache.

Cache includes all lookup columns used in the maping
Cache includes all lookup out put ports in the

lookup condition and the
lookup/return port.

Support user defined default
values Does not support
user defiend default values

How to create different types of templates?

979

---

Where the data cube technology is used?

944

---

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

922

---

What is fact less fact table? Where you have used it in your project?

986

---

Difference between cold fusion 5 and cold fusion mx 6?

984

---

What is meant by metadata in context of a data warehouse and how it is important?

1192

---

What is the main difference between inmon and kimball philosophies of data warehousing?

1107

---

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

898

---

How did you plan your Data ware house project?

2290

---

What are the different methods of loading dimension tables?

986

---

What are algorithms provided by Microsoft in SQL Server?

2038

---

Explain what are components of reportnet?

957

---

What is loop in data warehousing?

1120

---

Explain a mapping, session, worklet, workflow, mapplet?

1089

---

In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

1036

---