Interested to Buy Any Domain ? << Click Here >> for more details...
Could any one to tell How to use the Oracle Analytic
functions in Informatica?
- 1 Answers
- 11824 Views
- I also Faced
- E-Mail Answers
Answer Posted / sabyasachi
Some of theOracle Analytical functions are like DENSE_RANK
(), RANK(),CUM_DIST(),CUM_AVG() etc. One get the
fuctionalities of some of these functions such as rank by
using a rank transformation.
For other types of functions one can resort to custom
transformation.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is repository manager?
What is a rank transform?
What is a joiner transformation and why it is an active one?
What do you understand by term role-playing dimension?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
server hot-ws270 is connect to Repository B. What does it mean?
How to join three sources using joiner? Explain though mapping flow.
What all are steps in up gradation of Informatica server?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How union transformation is used?
what is index?how it can work in informatica
How does the aggregator transformation handle null values?
What are the popular informatica products?
