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 |
why we are using level option in normalizer transformation
difference between repository database and repository service?
Explain the scenario which compels informatica server to reject files?
Explain incremental aggregation in informatica
how we can update a target table without update strategy and update override?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
which one is better either active or passive transformation in informatica
Under which circumstances, informatica server creates reject files?
Separate from an archive server and a powerhouse?
What is status code?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....