What are the steps involved in etl process?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference steps for data modeling?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is a staging area? What is the purpose of a staging area?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
Which transformation we use to convert 'NA' to 'Not Available'
What is the difference between project backlog and product backlog?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
what is the difference between normal & bulk loading? and which one is recommended ? why?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is partitioning? Explain different types of partitioning?
Explain the use lookup tables and Aggregate tables?