what is junk dimension
Answers were Sorted based on User's Feedback
Answer / jani basha
A dimension which can't be used to describe facts is know as junk dimension
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sairam
afact table which contains only flagging values
(indicators) then we will call it as junk dimension
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
What is a configuration management?
Can we create two repositories on same database instance in oracle?
What are the differences between source qualifier and joiner transformation?
How to handle changing source file counts in a mapping?
comonly how meny mappings r there in Banking projects?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
what is degenerated dimension table with scenario
How many joins in Informatica
How to delete the data in the target table after loaded.
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
what are the different types of transformation available in informatica and what are the mostly used ?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?