Could any one to tell How to use the Oracle Analytic
functions in Informatica?
- 1 Answers
- 11454 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is difference between a connected look up and unconnected look up?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
which one is better either active or passive transformation in informatica
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
How mapping parameter and variable works
Which are the different editions of informatica powercenter that are available?
Can anyone tell me the new features in Informatica 9 Version?
Define mapping and session?
What are the disadvantages of Sequence Generator T/R?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
what is a transforamation?
what type of problem you faced insales project or insurance project
Teradata 
