what is degenerated dimension?
Answer / priyank
There are some keys which are present in the fact table but
they do not have a corresponding Dimension table related to
them. These are called Degenerated Dimensions.
Eg. Transaction No., Invoice No.
| Is This Answer Correct ? | 1 Yes | 0 No |
In target table how to display the system time
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
What is persistent lookup cache?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
Repository user profiles
What is a predefined event?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
Does an informatica transformation support only aggregate expressions?
What are batches?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is confirmed fact in dataware housing?