Answer Posted / vikram

Diff between RANK() and DENSE_RANK():-
------------*******-----************-------

RANK():-
---> It leaves a gap in the sequence of ranking in the
event of tie.
DENSE_RANK():-
---> It doesn't leave a gap in the sequence of ranking
in the event of tie.

EX:-
empno ename RANK DENSE_RANK
101 AAA 1 1
102 BBB 2 2
102 BBB 2 2
102 BBB 2 2
103 CCC -->5 --> 3
103 CCC 5 3
104 DDD -->7 --> 4

How to drill through from a powerplay cube to reportnet?

939

---

Explain what are the various methods of getting incremental records or delta records from the source systems?

969

---

Explain what are data marts?

1127

---

What is surrogate key? Where we use it?

997

---

How can we determine what records to extract?

1083

---

Explain the structure of cold fusion?

1043

---

Explain the differences between normalizer and normalizer transformation?

1030

---

Explain the difference between view and materialized view?

948

---

How to improve session performance in aggregator transformation?

984

---

What are necessary tasks to install reportnet software?

922

---

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

982

---

Why we use repository connectivity?

984

---

What is the difference between a primary and secondary actor in use case modeling?

1066

---

in general which algorithms for used?

2028

---

What is a core dimension?

1071

---