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 |
How does a sorter cache works?
How do we implement materialized view?when to use materialized view?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
how do u fnd the duplicate rows and how to delete the duplicate rows?
how many ways can we implement SCD2?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
What is data transformation manager process?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
What is the difference between a table and the materialized view?