what is meant by drill through?(Mascot)
Answer / dfsg
navigating from one report (may be parent report) to
another report (may be child report ) irrespective of the
hierarchies is known as drill-through.
additional info:
drill up & drill down
if navigation happens in the same dimension
drill across
if navigation happens between domensions
| Is This Answer Correct ? | 1 Yes | 0 No |
What is tracing level? How many types of transformations supported by sorted input?
What are the new features of informatica 9 version?
Define slowly changing dimensions (SCD)?
What is staging area referring to?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Explain do we need an etl tool?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
how do u really know that paging to disk is happening while u are using a lookup transform?
how would u estimate the size of Lookup transform data and index cache?
what is dynamic insert?
Which transformation we use to convert 'NA' to 'Not Available'
What is etl tool in hadoop?