what is junk dimension

Answer Posted / chandrasekar

In a dimension a particular attribute cannot performed by
any key performance indicator. It is called junk dimension.

For example Phone number is a junk dimension.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is powercenter on grid?

696


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

626


How many ways a relational source definition can be updated and what are they?

581


How does a sorter cache works?

571


What is the session task and command task?

599






What do you mean by enterprise data warehousing?

644


During the running session, output files are created by informatica server. Enlist few of them.

541


What is the format of informatica objects in a repository?

603


What is the benefit of session partitioning?

597


Differentiate between a database and data warehouse?

654


Clarify the utilization of aggregator cache record?

578


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1627


State the differences between sql override and lookup override?

622


what is diff b/t sorter t/r and agg have the option sorter property...

1748


How do you remove duplicate records in informatica? And how many ways are there to do it?

715