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 |
Write the advantages of partitioning a session?
What are the conditions needed to improve the performance of informatica aggregator transformation?
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
What are the different types of olap? Give an example?
what is mean by flag 4 in update strategy t/r
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
What is meant by lookup transformation?
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
What is polling?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?