Answer Posted / srinivas reddy
A Dimension with the type of descriptive information like flog,button or not used describe the key performance indicators known as facts is called as junk dimension
ex: product description,phone,fax, address ,etc..
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
For faster process, what we will do with the universe?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What are data validation strategies for data mart validation after loading process?
Explain what is fact less fact table? Where you have used it in your project?
what are the all possible features supported modify stage?
Explain difference between data ware house & data mart?
if you use oracle sql*loader , how do you transform data with it during loading?
What is the data type of the surrogate key?
How to export mappings to the production environment?
What is the difference between power center and power mart?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
How to create different types of templates?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is data stream and data adaopter?