As you said you have worked on info cubes and ods, which one is better suited for reporting? Explain and what are the drawbacks and benefits of each one?

35

---

When filling the set tables, is there any need of delete the setup tables?

43

---

What is an embedded dataflow?

941

---

What are business objects?

913

---

Describe when to use the usa regulatory and global address cleanse transforms?

884

---

A project requires the parsing of names into given and family, validating address information, and finding duplicates across several systems. Name the transforms needed and the task they will perform?

795

---

Define the Term 'dataflow'?

939

---

What are the differences between row-by-row select and cached comparison table and sorted input in table comparison transform?

891

---

What is the difference between lookup (), lookup_ext () and lookup_seq ()?

2383

---

What is the use of compact repository?

1385

---

Which will the size of a database?

917

---

How many types of datastores are present in data services?

954

---

What is the difference between a parameter and a variable?

927

---

What is the source of metrics?

887

---

What are the different strategies you can use to avoid duplicate rows of data when re-loading a job?

896

---