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?

1002

---

What are business objects?

963

---

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

942

---

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?

841

---

Define the Term 'dataflow'?

984

---

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

946

---

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

2464

---

What is the use of compact repository?

1415

---

Which will the size of a database?

976

---

How many types of datastores are present in data services?

993

---

What is the difference between a parameter and a variable?

982

---

What is the source of metrics?

931

---

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

946

---