Answer Posted / maruthi

META-DATA-> DATA-ABOUT-DATA IN THE SENSE ETL REPOSITORIES
WILL STORE METADDATA OF ALL THE TABLES/SCHEMAS TO MPROCESS
DATA FROM SOURCE TO TARGET.SO IT WILL STORE THE TABLE
NAME ,COLUMN TYPE/LENGTH/NULL/KEY OR NOT IN SUCH A WAY
MATADATA WILL BE STORD IN ETL REPOSITORIES./

What are the data types present in bo? What happens if we implement view in the designer n report?

880

---

explain about dirty dimension?

1072

---

what is user variable in affinium campaign? and some real time examples.

4114

---

Explain some of modeling tools available in the market?

898

---

What is normalization, first normal form, second normal form, third normal form?

911

---

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

875

---

Explain what are conformed dimensions?

1024

---

What are situations where snowflake schema is better than star schema when the opposite is true?

931

---

Can a dimension table contain numeric values?

1006

---

What is drilling across?

930

---

Explain the main differences between star and snowflake schema?

921

---

What is the use of tabular model, tabular sql, tabular reference in real time application?

909

---

Can decision tree be implemented using SQL?

2065

---

What is data warehosuing hierarchy?

1052

---

How to improve session performance in aggregator transformation?

935

---