what is a junk dimension ?
Answer Posted / arpita
A dimension which cannot be used to indicate the key
performance indicators is known as junk dimension.....
eg: Address,Phone number,Faxno,Description......etc...
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is a node in Informatica?
Explain the aggregator transformation?
What is incremental aggregation?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the informatica performance improvement tips
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is the format of informatica objects in a repository?
How would you join a node to the already existing domain?
what are the Methods For Creating Reusable Transformations?
What is native users?
Which transformation should we use to normalise the COBOL and relational sources?
what is index?how it can work in informatica
How to convert multiple rows to single row (multiple columns) in informatica
Enlist few areas or real-time situations where informatica is required.