can any one explain me about junk dimension
Answers were Sorted based on User's Feedback
Answer / mike
the dimension which contains the qttribute that changes
very rarely is known as junk dimension.
correct me if i was wrong
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / ravi
A junk dimension is one which is combination of different
small dimensions
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / usha
It’s a dimension table which is used to keep junk attributes
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / akash
A junk dimension is a combination of attributes which are
rarely used.
| Is This Answer Correct ? | 0 Yes | 2 No |
What is the difference between lookup override and souce qualifier override ?
Define Update Override?
What does command task mean?
What are the types of caches in lookup? Explain them.
How does a rank transform differ from aggregator transform functions max and min?
Enlist the differences between database and data warehouse.
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
What is the use of code page?
Parameter and variable differences
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.