Explain what is etl process? How many steps etl contains explain with example?
No Answer is Posted For this Question
Be the First to Post Answer
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 advantage of persistent cache? when it should be used?
What is granularity? Please explain with example
if i have a query as flat file how can we load data to target table
Explain about round-robi?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
Explain me ETL project architecture in Detail?
what is SMP AND MPP?
what is the difference between cardinality and Nullability?
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.?
What is tracing level?
Explain etl mapping sheets?