What is junk dimention?
Answers were Sorted based on User's Feedback
Answer / krishna
A dimention table which is type of boolean or flag. its not
used in the business analysis
| Is This Answer Correct ? | 10 Yes | 0 No |
A Dimension which not participated in the key performance
indicator.
Eg : phone number, address.
If it is wrong means please mail me chandranmca2007@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chinmay
Junk dimesnion is aimension table consisting attributes
that do no belong to any fact table or any form of existing
dimesnion .
Usually it is used to hold indicator yes/no , true/false.
| Is This Answer Correct ? | 0 Yes | 0 No |
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
star and snowflake schema?
why we use materialized view over view?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
What happens if the info. Server doesn't find the session parameter in the parameter file?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
Could you explain what is enterprise data warehouse?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
what is data driven?
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
What is the reusable transformation?