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 |
How will you update the row without using update statergy?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
How to handle decimal places while importing a flatfile into informatica?
What is hash partition?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
how i will stop my workflow after 10 errors
Explain the shared cache and re-cache?
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.
What are mapplets?
What do you mean incremental aggregation?