How do you manage slowly changing dimensions? What are the fields required in managing different types if scd?

21

---

What are the different types of files can be used as source and target file format?

21

---

What is sap data services?

21

---

What is substitution parameter?

17

---

What is the use of query transformation?

17

---

What is sap data services designer? What are main etl functions that can be performed in designer tool?

15

---

How do you check the execution history of a job or a data flow?

19

---

You want to generate the quality reports in ds system, data validation, and documentation. Where you can see this?

15

---

Why do we need a staging area in an etl process?

23

---

You want to extract data from an excel work book. How you can do this?

23

---

Is file format in data services type of a data store?

23

---

List the data integrator transforms?

27

---

How do you improve the performance of data flows using memory datastore?

21

---

What are the different types of embedded data flow?

44

---

Is it possible that a workflow call itself in data services job?

141

---