Login/RegisterTechnical Interview Questions and Answers :: Informatica
1 / 94
No Discussion on this question yet!
2 / 94
Type of facts are:
Additive: Additive facts are facts that can be summed up through all of the
dimensions in the fact table. A sales fact is a good example for
additive fact.
Semi-Additive:Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others.
Eg: Daily balances fact can be summed up through the customers dimension but not through the time dimension.
Non-Additive:
Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.
Eg: Facts which have percentages, ratios calculated.
3 / 94
No Discussion on this question yet!
4 / 94
No Discussion on this question yet!
5 / 94
The Aggregator gives only one record as output. That only record will be last record.
6 / 94
Yes it can but not directly. Use look up override to concatenate required columns and take this concatenated to expression and separate all fields from concatenated one.
7 / 94
No Discussion on this question yet!
8 / 94
No Discussion on this question yet!
9 / 94
No Discussion on this question yet!
10 / 94
How to find 7th highest salary in Oracle SQL.
TABLE NAME: EMP
SELECT * FROM EMP E1 WHERE 7=(SELECT COUNT(DISTINCT(SALARY)) FROM EMP E2 WHERE E2.SALARY>=E1.SALARY);
