What is the difference between Data Warehousing and Data Mining?
No Answer is Posted For this Question
Be the First to Post Answer
what is an ETL or ETT? And what are the different types?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
how do u really know that paging to disk is happening while u are using a lookup transform?
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 the meant by Normalization and de-normalization?
what is the meaning of upgradation of Repository?
How etl testing is different from database testing?
What is grain of fact?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
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.?
how do u set partition points in the mapping?