What are main etl functions that can be performed in designer tool?
What is the use of conditionals?
How do you manage slowly changing dimensions? What are the fields required in managing different types if scd?
What are local and global variables in data services job?
What is the use of data flow in ds?
What is sap data services designer?
What is linked data store? Explain with an example?
What is a real time job in data services?
What is the template table?
Which is not a data store type?
Suppose you have updated the version of data services software? Is it required to update the repository version?
Why do we need a staging area in an etl process?
What are the different properties that you can set for a data flow?
What are different objects that you can add to a dataflow?
You want to extract data from an excel work book. How you can do this?